0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 1 22

created oct 1 22 anonymous