0

Please login or register to vote for this query.

(click on this box to dismiss)

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], avg(Reputation) as [AVG 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)

fork query

edited mar 5 anonymous

created jan 8 20 avalokan