Q&A about the site for students and teachers of all martial arts
SELECT tags.TagName ,COUNT(PostId) AS total_unique_posts 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 WHERE PostId IS NOT NULL GROUP BY tags.TagName ORDER BY total_unique_posts DESC