Testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select top 20 ps.postid, datepart(year,ps.creationdate) Years 
--count(*) ReviewNumber 
from posthistory ps
inner join posts p
on ps.postid = p.id and p.posttypeid = 1 and p.acceptedAnswerId is not null
where datepart(year,ps.creationdate) <=2018
--group by datepart(year,ps.creationdate)

Enter Parameters

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