Q&A for teachers and students of the Esperanto language
SELECT DATEPART(year, p.CreationDate) AS "year", COUNT(*) AS "# questions" FROM Posts p JOIN Users u ON u.Id = p.OwnerUserId WHERE p.Body LIKE 'collapse' AND (p.Body LIKE 'wavefunction' OR p.Body LIKE 'quantum') AND p.PostTypeId = 1 -- Questions GROUP BY DATEPART(year, p.CreationDate) ORDER BY year DESC