0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

-- Questions/Answers Ratio

select top 100 
    sum(case when p.PostTypeId = 2 then 1 else 0 end) as cc,
    sum(case when p.PostTypeId = 1 then 1 else 0 end) as dd,
    u.id as [User Link],
    u.Reputation
from posts p
join users u 
on p.owneruserid = u.id
where u.id is not null and 
p.CommunityOwnedDate is null and
(p.PostTypeId = 1 or p.PostTypeId = 2)
group by u.id,u.Reputation
order by dd desc

fork query

created may 2 11 YOU