(Un)answered questions over time


Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

select year(CreationDate) as year, count(*) as count,
 (select count(*)
  from Posts
  where year(CreationDate) = year(p.CreationDate)
  and PostTypeId = 1 and AcceptedAnswerId is null)
from Posts p
where PostTypeId = 1 and year(CreationDate) between 2010 and 2020
group by year(CreationDate)
order by year

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results