Q&A for users and developers of the Cardano cryptocurrency ecosystem
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