users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

SELECT 
    ROW_NUMBER() OVER (PARTITION BY location ORDER BY COUNT(*) DESC) AS row_num,
    location,
    COUNT(*) AS user_count
FROM 
    users
GROUP BY 
    location
ORDER BY 
    user_count DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results