Running totals, rankings and "latest row per key" without self-joins.
Made for you now: slide lessons from basics to production, usually with code and a quiz. See a finished one