Assembly interview question

Mostly On SQL, Join, nested query