Table Data

select wtr_plate_id,wtr_plate_province,count(*) from vehicle_wastetruck group by wtr_plate_id,wtr_plate_province having count(*)>1 order by 3 desc,2,1

1 records   187.5 ms
wtr_plate_idwtr_plate_provincecount
-7543к2