select dateadd(month, datediff(month, 0, t.CreationDate),...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cooking

Q&A for professional and amateur chefs

select dateadd(month, datediff(month, 0, t.CreationDate), 0) mo, count(iif(ReviewTaskStateId=3,1,null))*100.0/count(*) PctCloseTasksInvalidated
from ReviewTasks t
join PostsWithDeleted p on p.Id=t.PostId
where ReviewTaskTypeId=2
and t.DeletionDate is not null
and p.DeletionDate is null
and p.ClosedDate is null
group by dateadd(month, datediff(month, 0, t.CreationDate), 0)
order by dateadd(month, datediff(month, 0, t.CreationDate), 0)

Enter Parameters

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