Q&A for biology researchers, academics, and students
DECLARE @STARTDATE DATETIME = '2008-01-01' DECLARE @ENDDATE DATETIME = '2008-12-31' --05-31, 07-31, 08-31, 10-31, 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 id = 18731465 group by Year(question.creationdate) --order by Id asc