WINDOW is incredible. Probably among the most useful yet least understood areas of SQL.