SQL Top Categories by Demographic | Dataford Interview Questions

Write a SQL query using window functions to find the top three most popular Pin categories for each user demographic group.

Popularity is measured by the number of saved Pin interactions. Include only users with a known demographic group and return exactly three categories per group, breaking ties alphabetically by category.

Output

One row per demographic group and category.
Columns: demographic_group, category, save_count, and category_rank.
Sort by demographic_group, category_rank, then category.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Pinterest user identifier
demographic_group	VARCHAR(50)	User demographic segment

pins

Column	Type	Description
pin_idPK	INT	Unique Pin identifier
category	VARCHAR(100)	Content category assigned to the Pin

pin_interactions

Column	Type	Description
interaction_idPK	INT	Unique interaction identifier
user_id	INT	User who performed the interaction
pin_id	INT	Pin involved in the interaction
interaction_type	VARCHAR(30)	Interaction action, such as save or click

Your question is SQL Top Categories by Demographic. 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