SELECT REPLACE(Location, '', 'Na') as Location, Count(1) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT
REPLACE(Location, '', 'Na') as Location, 
  Count(1) as Skaits
FROM Users
WHERE DisplayName like 'Andr%'
GROUP BY Location
HAVING COUNT(1)>100
ORDER BY Skaits desc

Enter Parameters

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