Q&A for enthusiasts and power users of the Android operating system
DECLARE @STARTDATE DATETIME = '2008-01-01' DECLARE @ENDDATE DATETIME = '2008-12-31' SELECT year(question.creationdate), count(*) FROM Posts AS Question where Question.Tags LIKE '%java%' AND --Question.Body LIKE '%<code>%' and posttypeid = 1 --and datepart(year,creationdate) = 2008 --and question.creationdate BETWEEN @STARTDATE AND @ENDDATE --and AcceptedAnswerId is not null --and Score > 0 group by year(question.creationdate)