Database for Digital Marketers — 1.2 (Case Statement, Group By & Having)
The definition of the word “case” in Dictionary is “a set of circumstances or conditions” or “an instance of a particular situation” or “occurrence of a particular kind or category”.
I think the case statement in SQL closely resembles the last definition “occurrence of a particular kind or category”.
Let’s take the simple case of Customer Spend. You are starting a marketing campaign post-Christmas and would like to give a discount to your customers based on the spending this year.