Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- get all the data from Users table -- 
-- SELECT * 
-- FROM Users 

-- Generate Freq. Dist Table for User Reputation -- 
SELECT count(Id) AS ReputationCount
FROM Users 
WHERE CreationDate > '2024-01-01 00:00:00' AND Reputation > 100
GROUP BY Reputation -- x axis-- 
ORDER BY ReputationCount desc

-- GROUP BY -- 
-- SELECT Location, Sum(UpVotes) AS TotalUpvotes 
-- FROM Users
-- WHERE CreationDate > '2024-01-01 00:00:00'
-- GROUP BY Location

Enter Parameters

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