Top 3 Engaged Users by Month | Dataford Interview Questions

Your question is Top 3 Engaged Users by Month. Start with the requirements and the two tables on the right.

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

Problem

Canva wants to identify its most engaged users in the Canva editor each month. Write a PostgreSQL query that ranks users by the number of qualifying engagement events.

Requirements

Join users to editor events and group qualifying events by calendar month and user.
Count only design_edit, comment, share, and export events. Exclude other event types and NULL event types.
Return the top three users for each month, using user ID as the deterministic tie-breaker.
Display the month as YYYY-MM, the user name, event count, and rank.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Canva user identifier
display_name	VARCHAR(100)	User's display name

editor_events

Column	Type	Description
event_idPK	INT	Unique editor event identifier
user_id	INT	User associated with the event
occurred_at	TIMESTAMP	Timestamp when the editor event occurred
event_type	VARCHAR(30)	Type of editor activity