unique users to create a post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

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;

Enter Parameters

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