SQL and Data Manipulation | Dataford Interview Questions

Tell me about a time you solved SQL and Python problems and how you ensured correctness.

Using the provided email_events table, write a SQL query that demonstrates a simple aggregation and explain how you would validate its result with Python or independent checks.

Output

One row per event date with at least one completed event
Columns: event_date, completed_events
Sort by event_date in ascending order

Schema

email_events

Column	Type	Description
event_idPK	INT	Unique event identifier
event_date	DATE	Date on which the event occurred
event_type	VARCHAR(30)	Type of email event
status	VARCHAR(20)	Processing status of the event
recipient_count	INT	Number of recipients associated with the event

Your question is SQL and Data Manipulation. 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