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