Slide 45
Slide 45 text
H1
SELECT
COUNT(*) as numJobs,
SUM(jobs.fare + jobs.tip) as totalFare,
AVG(jobs.cleared - jobs.created) AS avgJobTimeInSeconds,
SUM(jobs.cleared - jobs.created) AS timePOBInSeconds,
MAX(jobs.distance) AS distanceLongestJobInMetres,
(SELECT pickup_sector FROM (
SELECT COUNT(*) as numPickups, pickup_sector FROM jobs
WHERE jobs.cleared >= $from AND jobs.cleared < $to
AND jobs.driver=$driverId
AND pickup_sector IS NOT NULL AND pickup_sector != ''
GROUP BY pickup_sector
ORDER BY numPickups DESC
LIMIT 1
) AS cpp) as mostFrequentPickupSector
FROM jobs
WHERE jobs.cleared >= $from AND jobs.cleared < $to AND jobs.driver = $driverId
#php #mysql #truestory #omg