I have made a lot of window function converts. It's amazing how many devs don't know about them. When I see a whole series of CASE statements + subqueries, it i

I have made a lot of window function converts. It's amazing how many devs don't know about them. When I see a whole series of CASE statements + subqueries, it is almost always possible to dramatically simplify the query with one or more window functions.