percentage of questions closed by tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Windows Phone Meta

Q&A about the site for enthusiasts and power users of Windows Phone OS

select 
  tags.tagname as [tag name],
  count(*) as [questions closed],
  tags.count as [total questions],
  (CONVERT(decimal,count(*)) / CONVERT(decimal,tags.count)) * 100 as [percent closed]
from 
  posts 
  inner join posttags on posts.id = posttags.postid
  inner join tags on tags.id = posttags.tagid
 where 
 tags.tagname in ('f#', 'c#', 'haskell', 'scala', 'clojure','ocaml','python','rebol','J','APL') and
   posts.closeddate is not null
group by tags.id, tags.tagname, tags.count

Enter Parameters

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