Negatively scored questions by # of close votes and answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

with all_posts as ( 
select q.Id
     , max(a.score) as ascore
     , count(distinct v.Id) as closevotes
  from Votes v
  join Posts q
    on v.PostId = q.Id
  left outer join Posts a
    on q.Id = a.ParentId
 where v.VoteTypeId = 6
   and q.Score <= 0
   and q.ClosedDate is null
 group by q.Id
       )
select closevotes as [Close Votes]
      , count(*) as [Questions]
      , sum(case when ascore is null then 1 else 0 end) as [No Answer]
      , sum(case when ascore <= 0 then 1 else 0 end) as [Unpositive Answer]
  from all_posts
 group by closevotes

Enter Parameters

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