"Bad" questions from new users in 2013-2014


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for WordPress developers and administrators

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) + 2
                     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

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