window functions

SQL interview questions developers actually face in technical screens: real query problems, performance tradeoffs, and what separates passing from failing answers.