Q&A about the site for enthusiasts and power users of Windows Phone OS
SELECT Users.Location, COUNT(*) AS num_users FROM Users WHERE Users.Location IS NOT NULL AND Users.Location != '' GROUP BY Users.Location ORDER BY num_users DESC