SQL for Weekly Completion Rates | Dataford Interview Questions

Write a SQL query to analyze operational performance by joining member, queue, and outcome tables and calculating weekly completion rates.

Use the provided tables to calculate results for every queue and every week represented by valid member outcomes. Treat an outcome with status completed as completed. Include queues with no outcomes in a represented week.

Output

One row per queue and week, with columns queue_name, week_start, total_outcomes, completed_outcomes, and completion_rate.
Include weeks beginning Monday, order by week_start, then queue_name.
Return completion rates as percentages rounded to two decimal places, using 0.00 when no outcomes exist.

Schema

members

Column	Type	Description
member_idPK	INT	Unique member identifier
member_name	VARCHAR(100)	Member display name

queues

Column	Type	Description
queue_idPK	INT	Unique operational queue identifier
queue_name	VARCHAR(100)	Operational queue name

outcomes

Column	Type	Description
outcome_idPK	INT	Unique outcome identifier
member_id	INT	Member associated with the outcome
queue_id	INT	Queue that handled the outcome
outcome_at	TIMESTAMP	Timestamp when the outcome was recorded
outcome_status	VARCHAR(30)	Outcome status, such as completed, pending, or failed

Your question is SQL for Weekly Completion Rates. 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