select top 10 count(u.Id) from Users u left join Posts p ...

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 top 10 count(u.Id)
from Users u left join Posts p 
on p.OwnerUserId = u.Id
where year(p.CreationDate)=2018 and p.PostTypeId != 1 and p.OwnerUserId is null;

Enter Parameters

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