Weekly Ops Performance SQL | Dataford Interview Questions

Write a SQL query to analyze weekly operational performance by team, including joins across multiple tables and trend metrics over time.

Use the provided operational tables and restrict results to January 2025. Include teams with qualifying operational activity and calculate weekly workload, completion performance, and change from the team's prior reported week.

Output

One row per team and reported week, with team_name, week_start, total_tasks, completed_tasks, total_minutes, avg_completed_minutes, completion_rate, and completed_change_vs_prior_week
Include only qualifying January 2025 activity and sort by team_name, then week_start

Schema

teams

Column	Type	Description
team_idPK	INT	Unique team identifier
team_name	VARCHAR(100)	Operational team name

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
team_id	INT	Assigned team identifier

operational_events

Column	Type	Description
event_idPK	INT	Unique operational event identifier
employee_id	INT	Employee responsible for the event
occurred_at	TIMESTAMP	Timestamp when the event occurred
status	VARCHAR(30)	Operational event status
duration_minutes	INT	Event duration in minutes

Your question is Weekly Ops Performance SQL. 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