SQL for Overdue Work by Owner | Dataford Interview Questions

Given tables for tasks, owners, and status updates, how would you find overdue work and summarize it by owner using SQL at Attentive?

Use 2025-02-01 as the reporting date. A task is overdue when its due date is before that date and its latest status is not Completed. Include tasks without status updates and tasks without an assigned owner.

Output

One row per owner, including Unassigned when applicable.
Columns: owner_id, owner_name, overdue_count, and overdue_task_ids.
Sort by overdue count descending, then owner name ascending.

Schema

owners

Column	Type	Description
owner_idPK	INT	Unique owner identifier
owner_name	VARCHAR(100)	Owner's display name
team_name	VARCHAR(100)	Attentive team assigned to the owner

tasks

Column	Type	Description
task_idPK	INT	Unique task identifier
task_name	VARCHAR(200)	Task title
owner_id	INT	Assigned owner, when one exists
due_date	DATE	Task due date
created_at	DATE	Task creation date

status_updates

Column	Type	Description
status_update_idPK	INT	Unique status update identifier
task_id	INT	Task associated with the update
status	VARCHAR(50)	Status recorded by the update
updated_at	TIMESTAMP	Timestamp when the status was recorded

Your question is SQL for Overdue Work by Owner. 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