Find Inactive Taskers | Dataford Interview Questions

Given two tables, Tasks and Taskers, write a query to find Taskers who have not completed a task in the last 3 months on TaskRabbit.

Treat a task as completed only when its status is completed and its completion date falls within the last three calendar months relative to CURRENT_DATE.

Output

Return one row per qualifying Tasker with tasker_id and tasker_name.
Include Taskers with no tasks, only older completed tasks, or no qualifying completed task.
Order by tasker_id ascending.

Schema

tasks

Column	Type	Description
task_idPK	INT	Unique identifier for the task
tasker_id	INT	Tasker assigned to the task
status	VARCHAR(30)	Current task status
completed_at	DATE	Date the task was completed

taskers

Column	Type	Description
tasker_idPK	INT	Unique identifier for the Tasker
tasker_name	VARCHAR(100)	Tasker's display name

Your question is Find Inactive Taskers. 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