Meta Interview Question

SQL/Hive queries with joins.