Q&A for practitioners of the art and science of signal, image and video processing
select tags.TagName ,COUNT(PostId) AS total_unique_posts from PostTags pt left join ( select distinct t.Id ,t.TagName from Tags as t left outer join TagSynonyms as ts on t.TagName = ts.TargetTagName or t.TagName = ts.SourceTagName where t.TagName like '%snowflake%' or t.TagName like '%airflow%' or ts.SourceTagName like '%snowflake%' or ts.TargetTagName like '%snowflake%' or ts.SourceTagName like '%airflow%' or ts.TargetTagName like '%airflow%' ) as tags on tags.id = pt.TagId group by tags.TagName order by total_unique_posts desc