0

Please login or register to vote for this query.

(click on this box to dismiss)

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%'

fork query

edited dec 3

created dec 3 anonymous