Utilisation rate per consultant
Utilisation is the share of a consultant's logged hours that were billable to a client.
For each consultant, return consultant, their total_hours, and utilisation_pct — billable hours as a percentage of total hours, rounded to 1 decimal place.
A row is billable when is_billable is true. Every consultant in timesheets should appear, including any with no billable hours at all.
Schema
▸timesheets
| id | INT |
| consultant | TEXT |
| work_date | DATE |
| hours | NUMERIC |
| is_billable | BOOLEAN |
Example input
▸timesheets
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.