Irwin Mitchell interview question

SQL joins, aggregate functions (including having)