J.P. Morgan interview question

Internal working of SQL commands(Round 2)