Most Recent Task Containing Keyword | Dataford Interview Questions

How would you search tasks from newest to oldest to return the most recent task that contains a given keyword substring?

Use the substring deploy for this exercise. Search both task titles and descriptions, treating NULL text as non-matching.

Output

Return at most one row with task_id, title, created_at, and creator_name.
Include the newest matching task only, ordered by created_at descending and task_id descending as the tie-breaker.
If the matching task has no corresponding creator, return NULL for creator_name.

tasks

Column	Type	Description
task_idPK	INT	Unique task identifier
title	VARCHAR(200)	Task title
description	TEXT	Detailed task description
created_at	TIMESTAMP	Time when the task was created
creator_id	INT	User who created the task

users

Column	Type	Description
user_idPK	INT	Unique user identifier
creator_name	VARCHAR(120)	Display name of the user

Your question is Most Recent Task Containing Keyword. 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.