SELECT COUNT(*) FROM Users WHERE id not in(SELECT DISTINC...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

--select count(*) from users;
    SELECT COUNT(*) FROM Users WHERE id 
    not in(SELECT DISTINCT(OwnerUserId) 
      FROM Posts as P
      WHERE year(CreationDate)=2018
        and p.posttypeid = 1);
        
        /*SELECT COUNT(*) 
        FROM Users as U
        JOIN Posts as P
          ON P.OwnerUserId = U.Id
        WHERE U.Reputation > 100
        AND (
        )*/

Enter Parameters

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