SQL, Pandas, and Case Study Live Coding | Dataford Interview Questions

Complete a live coding exercise with an SQL task, a Pandas/Python data manipulation task, and a case study follow-up.

For the SQL portion, use the provided tables to summarize January 2025 pin activity and saves. Return one row per creator with at least one January pin; creators with no January pins must be excluded.

Output

Columns: creator_id, creator_name, published_pins, total_saves, and avg_saves_per_pin
published_pins counts January pins, while total_saves counts January saves on those pins
Include qualifying creators with zero saves, round the average to two decimal places, and sort by total saves descending, then creator ID ascending

Schema

creators

Column	Type	Description
creator_idPK	INT	Unique creator identifier
creator_name	VARCHAR(100)	Creator display name

pins

Column	Type	Description
pin_idPK	INT	Unique pin identifier
creator_id	INT	Creator who published the pin
created_at	DATE	Date the pin was created

saves

Column	Type	Description
save_idPK	INT	Unique save event identifier
pin_id	INT	Pin that was saved
saved_at	DATE	Date the save occurred

Your question is SQL, Pandas, and Case Study Live Coding. 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