User Counts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Aviation Meta

Q&A about the site for aircraft pilots, mechanics, and enthusiasts

select 'All Users', count(*) as Cnt
from users

union all

select 'Count of Users that logged in within the last Year' as Category, count(*) as Cnt
from users
where lastaccessdate >= dateadd(yy, -1, getdate())

union all

select 'Count of Posters within the last Year', count(distinct owneruserid) as Cnt
from posts
where creationdate >= dateadd(yy, -1, getdate())

union all

select 'Count of Non-negative Posters within the last Year', count(distinct owneruserid) as Cnt
from posts
where creationdate >= dateadd(yy, -1, getdate())
    and Score >= 0

union all
    
select 'Count of Commenters within the last Year', count(distinct userid) as Cnt
from Comments
where creationdate >= dateadd(yy, -1, getdate())

union all

select 'Count of Voters within the last Year', count(distinct userid) as Cnt
from Votes
where creationdate >= dateadd(yy, -1, getdate())


select 'Count of Suggested Editors within the last Year', count(distinct owneruserid) as Cnt
from suggestededits
where creationdate >= dateadd(yy, -1, getdate())

Enter Parameters

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