Top Product Clicks by Region | Dataford Interview Questions

Credit Karma wants to identify the most-clicked financial products by user region. Write a SQL query that counts product clicks during the 30-day period ending on September 15, 2026, and returns the top three products for each known region.

Output

One row per qualifying region and product, with columns region, product_id, product_name, click_count, and product_rank.
Include only clicks from August 16, 2026 through September 15, 2026, inclusive, and exclude clicks whose user has no region.
Rank products within each region by descending click count, breaking ties by ascending product_id; return ranks 1 through 3.
Sort the final result by region, then product_rank. Clicks with NULL timestamps do not qualify.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Credit Karma user identifier
region	VARCHAR(50)	Geographic region associated with the user

financial_products

Column	Type	Description
product_idPK	INT	Unique financial product identifier
product_name	VARCHAR(100)	Name of the financial product

product_clicks

Column	Type	Description
click_idPK	INT	Unique product click event identifier
user_id	INT	User who clicked the product
product_id	INT	Product that was clicked
clicked_at	TIMESTAMP	Timestamp when the product was clicked

Your question is Top Product Clicks by Region. 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