SELECT TOP 20 YEAR(CreationDate) [year], p.Id, t.value F...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

--SELECT COUNT(*) FROM Posts;  -- 54255054
--SELECT COUNT(*) FROM Posts WHERE PostTypeId = 1;  -- 21769820

SELECT TOP 20 YEAR(CreationDate) [year], p.Id, t.value
  FROM Posts p
 OUTER APPLY (
     SELECT REPLACE(REPLACE(value, '<', ''), '>', '') value
       FROM STRING_SPLIT(p.Tags, '>')) t
 WHERE PostTypeId = 1 -- questions

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results