顺丰秋招笔试SQL 8/20

顺丰秋招笔试SQL 8/20

我的mysql代码：

select  b.dept_name as '网点名称', date_format(a.receive_time,'%Y-%m-%d') as '收件日期',
    hour(a.receive_time) as '收件小时' ,
    count(a.dept_code) as '件数'
    from waybill_info_a a  join waybill_info_b b
    on a.dept_code=b.dept_code
    group by a.receive_time
    order by '收件日期';

结果

想不通代码哪里出错了，还请广大网友指点明津。