1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students and teachers of all martial arts

select [tag left], [python], [pandas]

from (
select ptl.postid, tl.tagname [tag left], tr.tagname [tag right] 
from posttags ptl
inner join tags tl on tl.id = ptl.tagid
inner join posttags ptr on ptr.postid = ptl.postid and ptr.tagid <> ptl.tagid
inner join tags tr on tr.id = ptr.tagid
) data
pivot (
  count(postid)
  for [tag right] in ([python], [pandas])
) pvt
order by 2 desc

view current version

edited jan 2 23

created jan 2 23 rene