close votes per tag


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select tag
, count(*) as [count]
select distinct
       t.tagname as tag
 from votes v
 inner join posts p 
    on = v.postid
 inner join posttags pt 
    on pt.postid =
 inner join tags t 
    on = pt.tagid
 where v.votetypeid = 6 -- close
 and p.posttypeid = 1 -- question
 and p.closeddate is null
 ) as tqc
 group by  tag
 order by count(*) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results