Meta Interview Question

SQL questions based on JOINS, SUBQUERY, AGGREGATE functions and GROUP BY.