0

Please login or register to vote for this query.

(click on this box to dismiss)

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 as P
      WHERE year(CreationDate)=2018
        and p.posttypeid = 1
        and OwnerUserId IS NOT NULL);*/
        
        SELECT TOP 15 p.tags,u.id--COUNT(U.id) 
        FROM Users as U
        JOIN Posts as P
          ON P.OwnerUserId = U.Id
        WHERE U.Reputation > 100
        AND P.PostTypeId = 1
        AND (P.Tags LIKE '%<sql>%' 
          OR 
        P.Tags LIKE '%<java>%');

fork query

edited nov 12

created nov 12 anonymous