SELECT SUM(Skaits) FROM ( SELECT Pos.Id, Count(1) AS Skaits

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT
SUM(Skaits)
FROM
(
SELECT Pos.Id, Count(1) AS Skaits
FROM Posts AS Pos
JOIN PostTags AS PosTgs ON Pos.Id=PosTgs.PostId
 WHERE EXISTS 
   (SELECT * FROM Tags AS Tag 
      WHERE Tag.Id=PosTgs.TagId 
      AND (UPPER(Tag.TagName)='JAVA'
      OR UPPER(Tag.TagName)='CSS')
     )
GROUP BY Pos.Id
)
AS Details

Enter Parameters

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