Q&A for materials modelers and data scientists
--SELECT COUNT(*) FROM Posts; -- 54255054 --SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1; -- 21769820 SELECT TOP 50 [year], Tag, COUNT(*) QuestionCount FROM ( SELECT YEAR(CreationDate) [year], p.Id, t.Tag FROM Posts p OUTER APPLY ( SELECT REPLACE(REPLACE(value, '<', ''), '>', '') Tag FROM STRING_SPLIT(p.Tags, '>') WHERE LEN(value) > 0) t WHERE PostTypeId = 1 ) raw -- questions WHERE [year] IN (2021) GROUP BY [year], Tag ORDER BY COUNT(*) DESC --SELECT MAX(CreationDate) FROM Posts WHERE PostTypeId = 1;