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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biology

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

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