Query 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arts and Crafts Meta

Q&A about the site for artists and crafters

select temp4.value, count(temp4.value) from (

select temp3.value from (
  select * from (select Top 10 Tags from Posts where  YEAR(CreationDate) = '2020') as temp1
  CROSS APPLY STRING_SPLIT(Tags, '<')) as temp2
CROSS APPLY STRING_SPLIT(value,'>') as temp3

) as temp4
group by temp4.value

Enter Parameters

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