Junior data analyst interview · question 2
Be sure of the number before you say it.
Marketing’s slide says: “AUTUMN20 brought 2,003 customers in the promo week.” This is the query behind it. Can the slide go out?
SELECT COUNT(*)
FROM orders
WHERE promo_code = 'AUTUMN20'
AND status = 'paid'| COUNT(*) |
|---|
| 2,003 |
Pick your answer
New to SQL? Learn SQL from zero — free Keep your progress: free account