Aon interview question

SQL basic questions on joins, subqueries