Q&A for Tridion developers and administrators
SELECT DATEPART(year, p.CreationDate) AS "year", COUNT(*) AS "# questions" FROM Posts p JOIN Users u ON u.Id = p.OwnerUserId WHERE p.PostTypeId = 1 -- Questions GROUP BY DATEPART(year, p.CreationDate) ORDER BY year DESC