Aged-away close reviews by week

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

select dateadd(week, datediff(week, 0, t.CreationDate), 0) wk, count(*)
from ReviewTasks t
where ReviewTaskTypeId=2
and ReviewTaskStateId=3
and t.CreationDate < dateadd(week, datediff(week, 0, getdate()), 0)-1
group by dateadd(week, datediff(week, 0, t.CreationDate), 0)
order by dateadd(week, datediff(week, 0, t.CreationDate), 0)

Enter Parameters

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