/* Use the badges table to show badge name (as name) and ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

/* Use the badges table to show badge name (as name) and the number of 
people who won it (as badge_count), limiting results to badges with at 
least 20 winners. */

/* SELECT UserID, COUNT(*)
FROM Badges
GROUP BY name; */


/* Find users who report being located in 'New York, NY’ city. 
Report id, displayname, and location in your result set. */


SELECT Id, DisplayName, Location FROM Users
WHERE Location='New York, NY';

Enter Parameters

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