Deloitte interview question

Queries based on joins and aggregate functions.