Junior data analyst interview · question 5

Be sure of the number before you say it.

Week of 21 September: sales −91% on the week before. Your manager wants to warn the CEO today. What do you say?

SELECT date_trunc('week', created_at),
       SUM(items_total_eur)
FROM orders
WHERE status = 'paid'
GROUP BY 1
ORDER BY 1