0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

WITH 
	htmltag as (
		SELECT psttg.PostId 
		FROM PostTags psttg 
		WHERE psttg.TagId=(SELECT Id FROM Tags WHERE UPPER(TagName)='CSS')
		)
	,cstag  as (
		SELECT psttg.PostId 
		FROM PostTags psttg 
		WHERE psttg.TagId=(SELECT Id FROM Tags WHERE UPPER(TagName)='HTML')
		)
SELECT Top 10 
	 pst.Title
	,MAX(pst.answerCount) as answer_count
FROM Posts pst
	Inner Join htmltag ht ON ht.PostId=pst.Id
    Inner Join cstag cs ON cs.PostId=pst.Id
GROUP BY pst.Title
ORDER BY 2 DESC

fork query

edited nov 6

created nov 5 anonymous