sql по боту выгрузку количество людей по городам

SELECT COUNT(*) AS kol, `city` FROM `users` GROUP BY `city` ORDER BY kol DESC