Interview pack

Window functions deep-dive

The window-function questions in the bank, back to back — ranking, running totals, LAG/LEAD and NTILE, the topic that trips up the most candidates.