"Bad" questions from new users in 2013-2014

0

Please login or register to vote for this query.

(click on this box to dismiss)

WordPress

Q&A for WordPress developers and administrators

--http://meta.wordpress.stackexchange.com/posts/3745/revisions
declare @epoch datetime = 'March 1, 2014'


select dateadd(month, datediff(month, @epoch, u.CreationDate), @epoch) Month,
       iif (q.DeletionDate is null
            and q.ClosedDate is null, 'good', 'bad') quality,
       count(*) questions
from Users u 
     join PostsWithDeleted q on OwnerUserId = u.Id 
                     and datediff(month, @epoch, q.CreationDate)
                         < datediff(month, @epoch, u.CreationDate) + 5
                     and PostTypeId = 1
where u.CreationDate between 'January 1, 2013' and 'January 1, 2015'
group by datediff(month, @epoch, u.CreationDate),
         iif (q.DeletionDate is null
            and q.ClosedDate is null, 'good', 'bad')
            order by Month, quality desc;

Enter Parameters

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