WITH Posts_HTML_CSS as ( SELECT DISTINCT ptag.PostId FROM...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

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) in ('HTML','CSS')
	)
SELECT Top 10
	 COALESCE(pst.Title, 'N/A') as Title
    ,pst.Id
	,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'),pst.Id
ORDER BY 2 DESC
;

Enter Parameters

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