Moderator reviews on accepted answers by YEAR

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

select YEAR(v.creationdate) as "Year", COUNT(distinct v.postid) as "Count"
from posts p
join votes v on p.acceptedanswerid = v.postid
where v.votetypeid = 15 --- reviewed by moderator
group by YEAR(v.creationdate)
order by YEAR(v.creationdate)

Enter Parameters

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