peletakan group by having count

select city, COUNT(city) as jumlah
   FROM
   sales.customers 
   group by city 
   having count(city) > 3
   ORDER BY jumlah ASC

Tweet