2020-02-19
阅读量:
1001
近一个月完单大于30单的司机姓名及电话
select driver_name,driver_phone
from driver_info left join driver_collect on driver_info.driver_id=driver_collect.driver_id
where d_year=2017 and d_month=7
group by driver_info.driver_id
having count(order_id)>30;






评论(0)


暂无数据
推荐帖子
0条评论
1条评论
0条评论