0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in the history and origins of science and mathematics

DECLARE @maVariable varchar(20) = '##maVariable##'
IF(LEN(@maVariable) > 4)
BEGIN 
select top 10(u.DisplayName), count(p.Id) as nbrQuestion, count(b.Id)
from Users u
join Posts p on u.Id = p.OwnerUserId
join Badges b on u.Id = b.UserId
where p.PostTypeId=1 group by u.DisplayName
END

fork query

edited dec 21 18

created dec 18 18 anonymous