Top Users by Country

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

SELECT 
    (CASE WHEN LOWER(Location) LIKE '%denmark%' THEN 'denmark'
    WHEN LOWER(Location) LIKE '%egypt%' THEN 'egypt'
    WHEN LOWER(Location) LIKE '%estonia%' THEN 'estonia'
    WHEN LOWER(Location) LIKE '%finland%' THEN 'finland'
    WHEN LOWER(Location) LIKE '%france%' THEN 'france'
    WHEN LOWER(Location) LIKE '%germany%' THEN 'germany'
    WHEN LOWER(Location) LIKE '%ghana%' THEN 'ghana'
    WHEN LOWER(Location) LIKE '%greece%' THEN 'greece'
    END) as country, COUNT(Id)
FROM 
    Users
WHERE
    Reputation >= 1000
GROUP by     (CASE WHEN LOWER(Location) LIKE '%denmark%' THEN 'denmark'
    WHEN LOWER(Location) LIKE '%egypt%' THEN 'egypt'
    WHEN LOWER(Location) LIKE '%estonia%' THEN 'estonia'
    WHEN LOWER(Location) LIKE '%finland%' THEN 'finland'
    WHEN LOWER(Location) LIKE '%france%' THEN 'france'
    WHEN LOWER(Location) LIKE '%germany%' THEN 'germany'
    WHEN LOWER(Location) LIKE '%ghana%' THEN 'ghana'
    WHEN LOWER(Location) LIKE '%greece%' THEN 'greece'
    END)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results