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
Investigate this case →