Meta Interview Question

SQL Joins, SQL windows functions