SQL Window Functions: The Thing That Separates Beginner Queries From Analyst Queries
There is a moment in most analysts’ careers where they stop writing SQL that works and start writing SQL that is good. For a lot of people, that moment is window functions. Before you learn them, certain problems feel genuinely impossible in SQL. Rank each salesperson within their region. Show each month alongside the previous … Read more