题解 | #2021年国庆在北京接

为啥我的不对啊。。。。。。。。。。。。呜呜呜

select 
city='北京'
,AVG (ord_amt) as avg_order_num
,avg (amount) as avg_income
from 
(
select 
driver_id
,sum (fare) as  amount
,count( order_id) as ord_amt
from 
tb_get_car_order
join tb_get_car_record
using (order_id)
where date_format(start_time,'%y%m%d') between '20211001' and '20211007'
and city='北京'
group by driver_id
having count(order_id)>3);