40+ SQL questions: JOINs, GROUP BY, window functions (ROW_NUMBER, RANK), CTEs, subqueries, query optimisation, and real analyst scenarios.