/*SELECT Count (*) FROM Users WHERE Id NOT IN ( SELECT DI...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

/*SELECT Count (*) 
FROM Users
WHERE Id NOT IN (
  SELECT DISTINCT (OwnerUserId)
  FROM Posts 
  WHERE year(CreationDate) = 2018 AND PostTypeId = 1 AND OwnerUserId IS NOT NULL
  )*/
   
SELECT Count (*) 
FROM Users
WHERE (Reputation > 100) AND Id IN (
  SELECT (OwnerUserId) 
  FROM Posts 
  WHERE (OwnerUserId IS NOT NULL) 
    AND (PostTypeId = 1) 
    AND (Tags LIKE '%java%')
    AND (Tags LIKE '%sql%')
  )

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results