0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

SELECT
--	tag.TagName as Tag
	COUNT(1) as NumberOfPosts
FROM Posts pst
WHERE
    pst.Id IN (
        SELECT ptag.PostId
        FROM PostTags ptag
            Inner Join Tags tag ON tag.Id = ptag.TagId
        WHERE UPPER(tag.TagName) in ('JAVA','CSS')
    )
    and EXISTS (
        SELECT 1 FROM Comments com WHERE com.PostId = pst.Id
    )
--GROUP BY tag.TagName
;

fork query

edited nov 6

created nov 5 anonymous