Overdue Open Tasks per Project

As of 2026-09-01, count open tasks past their due date for each project that has any. Order by project.

Table schema

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

Sample data

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