Tasks Ready to Start

A task is ready when it is open and every task it depends on is done. Return ready task names ordered by id.

Table schema

Tasks(id INT PRIMARY KEY, project VARCHAR(10), name VARCHAR(10), status VARCHAR(10), due_date DATE)
Dependencies(task_id INT, depends_on INT)

Sample data

Tasks
id | project | name | status | due_date
1 | Web | Design | done | 2026-08-10
2 | Web | Build | open | 2026-08-25
3 | Web | Test | open | 2026-09-15
4 | App | Spec | done | 2026-07-30
5 | App | Code | open | 2026-08-20

Dependencies
task_id | depends_on
2 | 1
3 | 2
5 | 4