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 as (
	SELECT ptag.PostId
	FROM PostTags ptag
		Inner Join Tags tag ON tag.Id = ptag.TagId and UPPER(tag.TagName) = 'HTML'
	)
    ,Posts_CSS as (
	SELECT ptag.PostId
	FROM PostTags ptag
		Inner Join Tags tag ON tag.Id = ptag.TagId and 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 phtml ON phtml.PostId = pst.Id
    Inner Join Posts_CSS pcss ON pcss.PostId = pst.Id
GROUP BY COALESCE(pst.Title, 'N/A')
ORDER BY 2 DESC
;

fork query

edited nov 6

created nov 5 anonymous