0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

SELECT 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
    )
;

fork query

edited nov 6

created nov 5 anonymous