Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Tasks Blocking the Most Others

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.