2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

-- Percentage of closed questions per date
-- Show what percent of questions has been closed every day

with Questions as (
  select
    cast (CreationDate as date) as 'Date',
    (case when ClosedDate is null then 0 else 1 end) as ClosedQuestion
  from
    Posts
  where
    ParentId is null
)

select
  Date,
  PctClosed = 100 * sum(ClosedQuestion) / count(*)
from
  Questions
group by
  Date
order by 
  Date desc

fork query

edited may 5 12

created may 5 12 chrisaycock