Q&A for Drupal developers and administrators
SELECT Location, count(id) FROM Users group by Location;