Meta interview question

Advanced SQL: joins, subqueries, window functions