Top Users SQL Query | Dataford Interview Questions

Write an SQL query to find the top 3 users based on their interactions on a given day.

Use 2025-02-14 as the given day. Count only countable interaction types and interactions that are not deleted. Rows with a NULL interaction timestamp are ignored.

Output

Return up to three rows, one per user.
Include user_id, username, interaction_count, and rank.
Order by rank ascending. Break equal interaction counts by user_id ascending.

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique user identifier
username	VARCHAR(100)	User display name

interaction_types

Column	Type	Description
interaction_type_idPK	INTEGER	Unique interaction type identifier
interaction_type_name	VARCHAR(80)	Name of the interaction type
is_countable	BOOLEAN	Whether this interaction type contributes to user counts

interactions

Column	Type	Description
interaction_idPK	INTEGER	Unique interaction identifier
user_id	INTEGER	User associated with the interaction
interaction_type_id	INTEGER	Type associated with the interaction
occurred_at	TIMESTAMP	Timestamp when the interaction occurred
is_deleted	BOOLEAN	Whether the interaction has been deleted

Your question is Top Users SQL Query. Start with the requirements and the three 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