Depth of Data Analysis Experience | Dataford Interview Questions

How much data analysis have you done?

For this SQL exercise, demonstrate your experience by summarizing the supplied analyst and analysis run records for calendar year 2025. Include analysts with no qualifying runs.

Output

One row per analyst with analyst_name, completed_runs, total_records, average_quality_score, and workload_rank.
Include only completed runs in 2025; analysts without qualifying runs must remain with zero totals and a null average.
Rank analysts by total records in descending order, allowing ties, and sort ties alphabetically by analyst name.

Schema

analysts

Column	Type	Description
analyst_idPK	INT	Unique analyst identifier
analyst_name	VARCHAR(100)	Analyst's full name
team	VARCHAR(50)	Analyst's organizational team

analysis_runs

Column	Type	Description
run_idPK	INT	Unique analysis run identifier
analyst_id	INT	Analyst assigned to the run
status	VARCHAR(20)	Run status
completed_at	TIMESTAMP	Timestamp when the run completed
records_analyzed	INT	Number of records processed by the run
quality_score	DECIMAL(4,2)	Quality score assigned to the run

Your question is Depth of Data Analysis Experience. 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