Handle Missing Dates in SQL | Dataford Interview Questions

Explain how you would fill missing dates with zero counts using a date spine and cross join logic.

Return one row per calendar date in the requested range, including dates with no matching activity. Use the provided tables to produce daily counts with zeros where needed.

Output

One row per date in the full date range
Columns: activity_date, event_count
Include dates with no events, with event_count = 0
Sort by activity_date ascending

Schema

events

Column	Type	Description
event_idPK	BIGINT	Unique event identifier
event_date	DATE	Date the event occurred
event_type	VARCHAR(50)	Type of event
user_id	BIGINT	User associated with the event

Your question is Handle Missing Dates in SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem