Q&A for people looking to bypass life's everyday problems with simple tricks
select Location, count(*) from users where (location is not null) and (location <> '') group by Location order by count(*) desc