0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT Location, Id, DisplayName,
count(*) as "num located in NY"
FROM Users
WHERE location LIKE '%NY%'
AND location LIKE '%New York%'
GROUP BY location, id, displayname;

fork query

edited sep 27 21

created sep 27 21 anonymous