Project Completion Percentage

Return each project and the percentage of its tasks that are done, rounded to 2 decimals. 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