0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for teachers and students of the Esperanto language

SELECT
  CASE WHEN Location='' THEN 'Nav Norādīts' ELSE Location END as Location, 
  Count(1) as Skaits
FROM Users
WHERE DisplayName like 'Andr%'
GROUP BY Location
HAVING COUNT(1)>100
ORDER BY Skaits desc

fork query

edited nov 5

created nov 5 anonymous