单选题

快件信息表（waybillinfo）中存储了快件的所有操作信息，请找出在中...

Question

快件信息表waybillinfo(id, waybillno, zonecode, optype, update_time)中存储了快件的所有操作信息，请找出在'中山公园'网点，异常派送（optype='异常派件'）次数超过3次的快件(waybillno)，正确的sql为（）

A. select waybillno, count(*) from waybillinfo where zonecode='中山公园' and optype='异常派件'
and count(waybillno) >3

B. select waybillno, count(*) from waybillinfo where zonecode='中山公园' and optype='异常派件'
order by waybillno having count(*) > 3

C. select waybillno, count(*) from waybillinfo where zonecode='中山公园' and optype='异常派件'
having count(*) > 3

D. select waybillno from waybillinfo where zonecode='中山公园' and optype='异常派件'
group by waybillno having count(*) > 3