牛客266702841号

分类

/ 注册

全部文章（共2篇）

题解 | 每个城市中评分最高的司机信息

WITH temp AS ( select city, driver_id, round(avg(grade),1) as avg_grade, round(count(t1.order_id)/count(distinct date(order_time)),1) as ...

2025-05-20

0 17

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

select city, round(sum(cnt)/count(distinct driver_id),3) as avg_order_num, round(sum(1s)/count(distinct driver_id),3) as avg_income from( select dri...

2025-05-20

0 13