0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

WITH Posts_HTML_CSS as (
	SELECT DISTINCT ptag.PostId
	FROM PostTags ptag
		Inner Join Tags tag ON tag.Id = ptag.TagId
	WHERE UPPER(tag.TagName) = 'HTML'
    UNION All
    SELECT DISTINCT ptag.PostId
	FROM PostTags ptag
		Inner Join Tags tag ON tag.Id = ptag.TagId
	WHERE UPPER(tag.TagName) = 'CSS'
	)
SELECT Top 10
	COALESCE(pst.Title, 'N/A') as Title
	,MAX(pst.AnswerCount) as NumberOfAnswers
FROM Posts pst
	Inner Join Posts_HTML_CSS phc ON phc.PostId = pst.Id
GROUP BY COALESCE(pst.Title, 'N/A')
ORDER BY 2 DESC
;

fork query

edited nov 6

created nov 5 anonymous