EY Interview Question

Mainly about database queries using joins and aggregate functions.