Week 02
Problem set
This week builds directly on Week 1's CTEs. Window functions take two days because they are the single most asked topic in product-company SQL rounds. Day 12 is theory for the interview that follows the OA, and Day 13 is a timed problem set; keep Day 14 for revision.
Window Functions, Dates & Company-Level Problems5 topics