Questions in last year by users below 15 vs at or above

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select  'Questions by users below 15 rep', count(1)
from    Posts
where   CreationDate > DateAdd(year, -1, GetDate())
and     PostTypeId = 1
and     OwnerUserId in (
        select Id from Users where Reputation < 15
)
union
select  'Questions by users at 15 rep or higher', count(1)
from    Posts
where   CreationDate > DateAdd(year, -1, GetDate())
and     PostTypeId = 1
and     OwnerUserId in (
        select Id from Users where Reputation >= 15
);

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results