BTO Research interview question

query di SQL, join, select