Running Totals for Event Counts | Dataford Interview Questions

How would you compute running totals for event counts?

Write a PostgreSQL query using discord_events and event_types. Ignore events with missing dates or event types that do not match a row in event_types.

Output

One row per event type and event date.
Columns: event_name, event_date, event_count, and running_total.
running_total must include all events for that type through the displayed date.
Order by event_name ascending, then event_date ascending.

Schema

event_types

Column	Type	Description
event_type_idPK	INT	Unique event type identifier
event_name	VARCHAR(100)	Descriptive name of the event type

discord_events

Column	Type	Description
event_idPK	INT	Unique event identifier
event_type_id	INT	Referenced event type identifier
event_date	DATE	Calendar date on which the event occurred

Your question is Running Totals for Event Counts. Start with the requirements and the two tables 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