.list name: DEU-ST L235
| Route Stats |
|---|
Query failed: SELECT
COUNT(*) as numDrivers,
SUM(cr.clinched) as numClinched,
@numUsers := (
SELECT COUNT(DISTINCT traveler) FROM clinchedOverallMileageByRegion
) as numUsers,
ROUND(COUNT(*) / @numUsers * 100, 2) as drivenPct,
ROUND(SUM(cr.clinched) / @numUsers * 100, 2) as clinchedPct,
ROUND(SUM(cr.clinched) / COUNT(*) * 100, 2) as drivenClinchedPct,
GROUP_CONCAT(cr.traveler SEPARATOR ', ') as drivers,
GROUP_CONCAT(IF(cr.clinched = 1, cr.traveler, null) separator ', ') as clinchers,
ROUND(AVG(cr.mileage), 2) as avgMileage,
ROUND(r.mileage, 2) as totalMileage,
ROUND(avg(cr.mileage) / r.mileage * 100, 2) as mileagePct
FROM clinchedRoutes as cr
JOIN routes as r ON cr.route = r.root
WHERE cr.route = 'deust.l235'