Meta Interview Question

SQL questions with aggregate functions and involving two tables/subqueries/pivoting data