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 TRIM(Location) = '' THEN 'NULL'
      ELSE lower(right(rtrim(Location),charindex(' ',reverse(rtrim(Location))+' ')-1))
    END AS location,
    COUNT(Id) as number
FROM
    Users
WHERE
    Reputation >= ##Threshold##
        AND
    AboutMe LIKE '%[Rr]uby%'
GROUP BY CASE
      WHEN TRIM(Location) = '' THEN 'NULL'
      ELSE lower(right(rtrim(Location),charindex(' ',reverse(rtrim(Location))+' ')-1))
    END

    
ORDER BY number DESC

Enter Parameters

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