Accounts Created By Year, Average Reputation, Average Up Votes, Average Down Votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Signal Processing Meta

Q&A about the site for practitioners of the art and science of signal, image and video processing

SELECT convert(date, LastAccessDate) as [AccessDate], count(*) as [Number of Accounts], sum(Reputation) as [Total Reputation of Users], sum(Views) as [Total Views], sum(UpVotes) as [Total Up Votes], sum(DownVotes) as [Total Down Votes]
from Users
where convert(date, LastAccessDate) > '2017-12-31' and convert(date, LastAccessDate) < '2021-01-01'
group by convert(date, LastAccessDate)
order by convert(date, LastAccessDate)

Enter Parameters

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