0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT YEAR (p.CreationDate) AS YearDate,
       COUNT (p.Id) AS PostCount,
       SUM (p.CommentCount),
       COUNT (c.PostId) AS CommentCount
FROM Posts AS p
LEFT OUTER JOIN  Comments AS c ON p.Id = c.PostId
GROUP BY YEAR (p.CreationDate)
ORDER BY YEAR (p.CreationDate)

view current version

edited jun 4 23

created jun 4 23 jon.doe42064