Count the number of answers of ELL in a given year

1

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

-- How many answers do we have in terms of a given year?
-- Finding the total answers per post on ELL 

DECLARE @GiveYear int = ##GiveYear##
-- For example : 2013

Select Count(AnswerCount) AS [Total Answers]
from Posts
where 
  year(CreationDate) = @GiveYear

Enter Parameters

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