Each row represents one shipment handoff initiated by dispatcher_id and assigned to courier_id.
Use the seven calendar dates ending on the latest handoff_date in the table. The latest date is included, so the window begins six calendar days earlier.
An eligible staff member is any distinct ID that appears as either a dispatcher or a courier during this window. A dispatcher is high-volume when they initiate more than 10 handoffs during the same window.
Return one row containing the percentage of eligible staff members who are high-volume dispatchers. Express the result on a 0-to-100 scale, round it to two decimal places, and return 0 when the table is empty or the window contains no eligible staff.
Output
+----------------------------+---------+
| Column Name | Type |
+----------------------------+---------+
| high_volume_dispatcher_pct | decimal |
+----------------------------+---------+
+----------------------------+---------+
| Column Name | Type |
+----------------------------+---------+
| high_volume_dispatcher_pct | decimal |
+----------------------------+---------+
Explanation: Dispatcher 101 initiates eleven handoffs and qualifies. IDs 101, 202, and 303 are the three eligible staff members, so one out of three is 33.33%.
