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>%');