Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
/*SELECT COUNT(Id), Tags FROM PostsWithDeleted GROUP BY Tags HAVING Tags = '%Airflow%' or Tags = '%Snowflake%'*/ /*select Tags, COUNT(Id) FROM PostsWithDeleted GROUP BY Tags HAVING LOWER(Tags) LIKE '%airflow%' or LOWER(Tags) LIKE '%snowflake%'*/ select TagName, count(DISTINCT PostId) as c from PostTags pt inner join Tags t on pt.TagId = t.Id GROUP BY TagName HAVING LOWER(TagName) LIKE '%airflow%' or LOWER(TagName) LIKE '%snowflake%'