Learn why window function results must be filtered in an outer query or CTE, not the same WHERE clause.
You have a monthly_revenue(month, revenue) table and want to return only the months whose revenue grew more than 10% versus the previous month. Which approach works correctly?