Stackoverflow is dying in 5 years its ded - modified for year by year results only

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

/* 2008 */
/* get all where someone answered, someone accepted an answer*/
SELECT count(distinct a.id)
FROM Posts as a inner join Posts as b on
  a.id = b.parentid
WHERE 
  a.PostTypeId = 1 
  and a.creationdate between '2008-01-01' and '2008-12-31'
  and b.creationdate between '2008-01-01' and '2008-12-31'
  AND a.AcceptedAnswerid is not NULL
  and a.closedDate is null
  AND a.AnswerCount >= 1
  
/* get all where someone answered */
SELECT count(distinct a.id)
FROM Posts as a inner join Posts as b on
  a.id = b.parentid
WHERE 
  a.PostTypeId = 1 
  and a.creationdate between '2008-01-01' and '2008-12-31'
  and b.creationdate between '2008-01-01' and '2008-12-31'
  and a.closedDate is null
  AND a.AnswerCount >= 1

/* get all */
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 
  and creationdate between '2008-01-01' and '2008-12-31'
  and closedDate is null

Enter Parameters

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