percent of id to site by month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select dateadd(month, datediff(month, 0, CreationDate), 0) mo, 
  count(iif(Tags like '%identify-this-song%', 1, null))*100.0/count(*) PctIdentification,
  
  count(iif(Tags like '%identify-this-song%' and DeletionDate is null and ClosedDate is null, 1, null))*100.0/count(*) PctIdentificationRetainedNoClosed
from PostsWithDeleted
where PostTypeId=1
group by dateadd(month, datediff(month, 0, CreationDate), 0)
having count(iif(Tags like '%identify-this-song%', 1, null)) > 0
order by dateadd(month, datediff(month, 0, CreationDate), 0)

Enter Parameters

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