1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

-- Annual # of non-closed, non-deleted questions

select year(CreationDate) as Year, count(*) as Count from Posts
where PostTypeId = 1 and ClosedDate is null and DeletionDate is null
group by year(CreationDate)
order by Year asc

fork query

edited nov 25

created nov 25 Chris W. Rea