Q&A about the site for people who use Blender to create 3D graphics, animations, or games
SELECT location, user_count, RANK() OVER (ORDER BY user_count DESC) AS rank FROM ( SELECT location, COUNT(*) AS user_count FROM users GROUP BY location ) AS subquery ORDER BY rank;