SELECT `office_name`, COUNT(*) AS `total`
FROM `clients`
WHERE `client_status_code` = 'Active'
GROUP BY `office_name`
ORDER BY `total` DESC
 LIMIT 5000