Tags Used Frequently Together

1

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

Q&A for linguists, teachers and students of the Korean language

select [tag row], [snowflake-cloud-data-platform], [google-bigquery], [amazon-redshift]
from (
select ptr.postid, trow.tagname [tag row], tcol.tagname [tag col] 
from posttags ptr
inner join tags trow 
   on trow.id = ptr.tagid
inner join posttags ptc 
   on ptr.postid = ptc.postid
inner join tags tcol on tcol.id = ptc.tagid
) data
pivot (
  count(postid)
  for [tag col] in ([snowflake-cloud-data-platform], [google-bigquery], [amazon-redshift])
) pvt
order by 2 desc

Enter Parameters

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