Q&A for SharePoint enthusiasts
select location,Count(*) from users group by location order by Count(*) desc