Calculate the average upvotes for users with 1000-10000 reputation
Q&A for computer enthusiasts and power users
-- Average votes for mid-level users -- Calculate the average upvotes for users with 1000-10000 reputation SELECT COUNT(0) AS NumUsers, SUM(UpVotes) / COUNT(0) AS AvrUpVotes, SUM(DownVotes) / COUNT(0) AS AvrDownVotes FROM Users WHERE Reputation > 1000 AND Reputation < 10000;