/*SELECT COUNT(Id), Tags FROM PostsWithDeleted GROUP BY T...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

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 count_tags
FROM
	PostTags pt
	LEFT JOIN Tags t ON pt.TagId = t.Id
GROUP BY
	TagName
HAVING
	TagName
	LIKE '%airflow%'
	OR TagName
	LIKE '%snowflake%'
ORDER BY
	count_tags DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results