Tasks Blocking the Most Others
Medium
Project & Task Tracking
Return the task name that the largest number of tasks depends on, with that count.
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
3 | 1
5 | 4
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.