Count Weekdays Between Two Dates

For each project return the number of working days (Monday to Friday) between start_date and end_date inclusive. Order by id.

Table schema

Projects(id INT PRIMARY KEY, start_date DATE, end_date DATE)

Sample data

id | start_date | end_date
1 | 2026-10-05 | 2026-10-11
2 | 2026-10-05 | 2026-10-19