Deloitte interview question

SQL queries using basic joins and aggregate functions.