Questions and Answers in 2018

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(*) Count, pt.Name
FROM Posts p
JOIN PostTypes pt ON pt.Id = p.PostTypeId
WHERE p.PostTypeId IN (1, 2) 
  AND p.CreationDate BETWEEN '2018-01-01' and '2019-01-01'
  AND p.ClosedDate IS NULL 
GROUP BY pt.Name

Enter Parameters

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