Atterna
RUEN

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
Paid orders with the code in the promo week, from 14 September.

Pick your answer

New to SQL? Learn SQL from zero — free Keep your progress: free account