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

fork query

edited dec 3 21

created dec 3 21 anonymous