Customers With Strictly Increasing Purchases
SQL teaching model. Total each customer per year, compare every year with the one before it using LAG, and keep customers whose totals keep rising across consecutive years.
SQL teaching model. Total each customer per year, compare every year with the one before it using LAG, and keep customers whose totals keep rising across consecutive years.