Event Occurrence Counting | Dataford Interview Questions

Write a query to count occurrences of specific events in a dataset.

Use the event_log table and count these event types: equipment_alarm, batch_started, and batch_completed. Exclude all other event types and NULL event types.

Output

One row per requested event type, with columns event_type and event_count.
Sort by event_count descending, then event_type ascending to break ties.

Schema

event_log

Column	Type	Description
event_idPK	INT	Unique event identifier
event_type	VARCHAR(50)	Name of the recorded event
occurred_at	TIMESTAMP	Time when the event occurred

Your question is Event Occurrence Counting. 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