Top Actions by Cohort | Dataford Interview Questions

Given a table of user activity logs, write a query to identify the top three most frequent actions performed by each user cohort.

Exclude rows with a NULL cohort or action. Ties should be broken alphabetically by action.

Output

user_activity_logs

Column	Type	Description
activity_idPK	INT	Unique identifier for the activity log entry
user_id	INT	Identifier of the user who performed the action
cohort	VARCHAR(30)	User cohort label
action	VARCHAR(50)	Action recorded in the activity log
occurred_at	TIMESTAMP	Timestamp when the action occurred

Your question is Top Actions by Cohort. 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.

Given a table of user activity logs, write a query to identify the top three most frequent actions performed by each user cohort.

Exclude rows with a NULL cohort or action. Ties should be broken alphabetically by action.

user_activity_logs

Column	Type	Description
activity_idPK	INT	Unique identifier for the activity log entry
user_id	INT	Identifier of the user who performed the action
cohort	VARCHAR(30)	User cohort label
action	VARCHAR(50)	Action recorded in the activity log
occurred_at	TIMESTAMP	Timestamp when the action occurred

Your question is Top Actions by Cohort. 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.