0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

--SELECT TOP 100 *
--FROM Users
--WHERE LOWER(Location) LIKE '%latvia%'

SELECT Location, COUNT(Id) loc_count
FROM Users
WHERE LOWER(Location) LIKE '%latvia%' OR Location LIKE '%Riga %' OR Location LIKE '%Rīga %'
GROUP BY Location
ORDER BY loc_count DESC

fork query

edited dec 3

created dec 3 anonymous