Aon Interview Question

SQL basic questions on joins, subqueries