SQL Window Ranking by Cohort | Dataford Interview Questions

Write a SQL query using window functions to rank users by engagement within each cohort for NeuroFlow reporting.

Use the provided users and engagement_events data. Include users with no matching events, treat their engagement as zero, and allow tied users to share a rank.

Output

One row per user with user_id, cohort, total_engagement, and engagement_rank.
Include all users and order by cohort, rank ascending, then user ID ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
display_name	VARCHAR(100)	User display name
cohort	VARCHAR(30)	User reporting cohort

engagement_events

Column	Type	Description
event_idPK	INT	Unique engagement event identifier
user_id	INT	User associated with the event
engagement_score	INT	Engagement points recorded for the event

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the two tables are in the Question tab.

Problem