Routine~13min
The Invisible Discount
189 customers were shown a 10% discount at checkout and clicked "Apply". The system confirmed it. But every single one of them paid full price. The discount vanished.
Tables you'll query
promotionstransactions
What you'll learn
NULL HandlingCASE StatementsSELECT & Filtering