Meta interview question

SQL Joins, SQL windows functions