APTOnline interview question

Mostly SQL joins and queries.