Q&A for users and developers of the Cardano cryptocurrency ecosystem
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