Automating Reporting with SQL/Python | Dataford Interview Questions

How have you utilized SQL or Python to automate repetitive data extraction or reporting tasks?

For this hands-on version, demonstrate the SQL portion by producing a recurring monthly report from the provided program and work-log data. Include active programs even when they have no qualifying work logs.

Output

One row per active program for January 2025
Columns: program_id, program_name, report_owner, total_approved_hours, approved_entries, and active_log_days
Include only approved logs dated from January 1 through January 31, 2025; show zero totals where no qualifying logs exist
Order by total_approved_hours descending, then program_id ascending

Schema

programs

Column	Type	Description
program_idPK	INT	Unique program identifier
program_name	VARCHAR(100)	Program name
status	VARCHAR(20)	Current program status
report_owner	VARCHAR(100)	Person responsible for the report

work_logs

Column	Type	Description
log_idPK	INT	Unique work-log identifier
program_id	INT	Referenced program identifier
work_date	DATE	Date on which work was recorded
hours	NUMERIC(8,2)	Hours recorded for the work log
entry_status	VARCHAR(20)	Approval status of the work log

Your question is Automating Reporting with SQL/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