Questions/Answers Ratio


Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

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 Answers,
  sum(case when p.PostTypeId = 1 then 1 else 0 end) as Questions, as [User Link],
from posts p
  join users u 
    on p.owneruserid =
where is not null and 
p.CommunityOwnedDate is null and
(p.PostTypeId = 1 or p.PostTypeId = 2)
group by,u.Reputation
order by Questions desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results