SQL and Python Interview Focus | Dataford Interview Questions

Tell me about your experience with SQL and Python and what kinds of problems you typically solve with them.

For the SQL portion, demonstrate a representative data-manipulation solution using the provided analyst and work-log tables. Return active analysts even when they have no completed work entries.

Output

One row per active analyst with analyst_name, completed_entries, and total_hours
Include only completed work entries in the metrics
Sort by total_hours descending, then analyst_name ascending

Schema

analysts

Column	Type	Description
analyst_idPK	INT	Unique analyst identifier
analyst_name	VARCHAR(100)	Analyst display name
is_active	BOOLEAN	Whether the analyst is currently active

work_logs

Column	Type	Description
work_log_idPK	INT	Unique work-log identifier
analyst_id	INT	Analyst associated with the work entry
status	VARCHAR(20)	Work-entry status
hours	NUMERIC(8,2)	Hours recorded for the entry
work_date	DATE	Date of the work entry

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