Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation
-- Average votes for mid-level users -- Calculate the average upvotes for users with 1000-10000 reputation SELECT COUNT(0) AS NumUsers, AVG(UpVotes) AS AvrUpVotes, AVG(DownVotes) AS AvrDownVotes, AVG(datediff(day, CreationDate, GETDATE())) AS AvrDaysMember FROM Users WHERE Reputation > 1000 AND Reputation < 10000;