Get number of accepted answers in 2019

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT count(*)
FROM Posts q
INNER JOIN Posts a on q.AcceptedAnswerId = a.Id
WHERE year(a.CreationDate)=2019
      and q.PostTypeId = 1
      and a.PostTypeId = 2 -- answers

Enter Parameters

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