Handshake Interview Question

SQL assessment on joins, aggregation, subqueries