Why most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEs ( zaidesanton.substack.com )