Meta interview question

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