0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

---Find the number of users who report being located in the New York state. 
---These include people who report themselves in New York city or in the NY state. 
---Be as accurate as possible as the self-reported location may take different forms.
---Report id, displayname, and location in your result set. 

SELECT * 
FROM Users
WHERE Location in ('New York', 'New York City');

fork query

edited sep 29

created sep 29 anonymous