mysql语句

select *
FROM (SELECT count(*) as num, a.roadName
FROM accident a
WHERE a.area = 'A' and a.accidentTime >= '2018-07-02' AND a.accidentTime <= '2018-07-06'
GROUP BY a.roadName) t1
where 1=1
order by t1.num desc
limt 0,21;
这里将区域写死了。