select count(*) [deleted] , count(closeddate) [closed and...


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for biology researchers, academics, and students

select count(*) [deleted]
     , count(closeddate) [closed and deleted]
     , avg(datediff(d,creationdate, closeddate))  [avg days till closed]
     , avg(datediff(d,creationdate, deletiondate))  [avg days till deleted]
from postswithdeleted 
where deletiondate is not null
and tags like concat('%<', 'pharmacology', '>%')

Enter Parameters

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