The Traffic Calendar

Kindled's small support team is rostered against how busy the site is, and the rota is drawn a week at a time. The scheduler wants tracked activity totalled per calendar day for the first seven days that recorded anything, read in date order so the shape of the week is visible. Later days are next week's problem and should not appear.

events — one row per tracked action. user_id points at a row in users. event_type is one of signup, view_product, add_to_cart and purchase. event_date is the day the action happened. Nothing guarantees a person produces all four kinds, or any particular number of rows.

The table already exists in the database — there is nothing to create or load.

Task: Write a query that returns at most seven rows, with columns event_date and n — the number of tracked actions on that day — covering the seven earliest days on which anything at all was recorded, oldest day first.

Example output — shape only, on invented days. The rows run oldest first, not busiest first: