Q&A for spacecraft operators, scientists, engineers, and enthusiasts
-- Using the Users table, please query the 25 most frequent
-- “Reputation” values users have on the site.
--Please comment below your code something interesting this
-- result tells you about the “Reputation” field.
SELECT TOP 25 COUNT(*), Reputation FROM Users GROUP BY Reputation ORDER BY 1;
-- Question 1
--SELECT COUNT(DISTINCT(OwnerUserId)) FROM Posts;
--SELECT COUNT(DISTINCT(OwnerUserId)) FROM Posts WHERE OwnerUserId >=0;