Using SQL and Python | Dataford Interview Questions

Tell me about a time you used SQL and Python to solve a data problem at work, and what the final result was.

Explain the problem, the SQL analysis, how Python supported the work, how you validated the result, and the final outcome. Use the supplied tables to demonstrate the SQL portion.

Output

One row per owner and month containing owner_name, activity_month, total_records, completed_records, completion_rate_pct, and completed_value
Include records with no matching owner as Unassigned
Include only months containing records, ordered by owner_name, then activity_month

Schema

owners

Column	Type	Description
owner_idPK	INT	Unique owner identifier
owner_name	VARCHAR(100)	Owner display name

records

Column	Type	Description
record_idPK	INT	Unique record identifier
owner_id	INT	Owner associated with the record
created_at	TIMESTAMP	Record creation timestamp
status	VARCHAR(20)	Current record status
amount	NUMERIC(10,2)	Amount associated with the record

Your question is Using SQL and Python. 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