SELECT Tags, CreationDate, COUNT(Tags) FROM Posts CROSS A...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

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

GROUP BY Tags, CreationDate
ORDER BY CreationDate;

Enter Parameters

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