SELECT Tags, CreationDate, COUNT(*) FROM Posts CROSS APPL...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT Tags, CreationDate, COUNT(*)
FROM Posts
  CROSS APPLY STRING_SPLIT(REPLACE(REPLACE(Tags, '<', ''), '>', ','), ',')
  WHERE YEAR(CreationDate) = 2017
GROUP BY Tags, CreationDate;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results