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