Q&A for Drupal developers and administrators
select displayname, count(*) from users where location='South Africa' group by displayname order by count(*) desc