Meta interview question

SQL/Hive queries with joins.