题解 | 2021年国庆在北京接单3次及以上的司机统计信息

SELECT t.city, ROUND(AVG(t.order_num), 3) AS avg_order_num, 
ROUND(AVG(total_fare), 3) AS avg_income  
FROM(
SELECT tbo.driver_id, COUNT(*) AS order_num, SUM(tbo.fare) AS total_fare, tbr.city
FROM tb_get_car_order AS tbo
INNER JOIN tb_get_car_record AS tbr
ON tbo.order_id = tbr.order_id
WHERE tbr.city = '北京' AND DATE(tbo.order_time) BETWEEN '2021-10-01' AND '2021-10-07'
GROUP BY tbo.driver_id
HAVING order_num >= 3) AS t
GROUP BY t.city;