SQL Top 10% Creators by Engagement | Dataford Interview Questions

Write a SQL query to identify the top 10% of creators based on engagement metrics over the last 30 days.

Use the provided creators and creator_engagements tables. Treat engagement as the sum of likes, comments, and shares. Include creators with no qualifying activity, and use the current date as the reference date.

Output

One row per selected creator with creator_id, creator_handle, total_engagements, and creator_rank.
Include exactly the top 10% of creators, rounded up, with deterministic ordering by engagement descending and creator ID ascending for ties.
Sort by creator_rank ascending.

Schema

creators

Column	Type	Description
creator_idPK	INT	Unique creator identifier
creator_handle	VARCHAR(80)	TikTok creator handle

creator_engagements

Column	Type	Description
engagement_idPK	INT	Unique engagement record identifier
creator_id	INT	Creator associated with the engagement record
engagement_date	DATE	Date of recorded engagement
likes	INT	Number of likes
comments	INT	Number of comments
shares	INT	Number of shares

Your question is SQL Top 10% Creators by Engagement. Start with the requirements and the two 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