Q&A for Tridion developers and administrators
select top 100 * from PostTags pt left join ( SELECT Id ,TagName FROM Tags WHERE LOWER(TagName) LIKE '%snowflake%' OR LOWER(TagName) LIKE '%airflow%' ) as tags on tags.id = pt.TagId -- group by tags.TagName -- order by total_unique_posts desc where PostId is null