0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

/*SELECT DisplayName, Id, Location, Reputation
FROM Users
ORDER BY Reputation DESC*/

/*SELECT DisplayName, Id, Location, Reputation
FROM Users
WHERE Reputation >= 550000;*/

/*SELECT Class, Name, COUNT(*) AS "Badge Count"
FROM Badges
WHERE Date >= '2016-01-01'
GROUP BY Class, Name 
ORDER BY Class, Name;*/

SELECT DisplayName, Views, Count(*)
FROM Users
WHERE Views >= 40 AND Views <= 60
GROUP BY DisplayName, Views
ORDER BY DisplayName, Views;

fork query

edited may 29 20

created may 29 20 anonymous