Percentage of "good" sql answers in last 12 months that used sqlfiddle

1

Please login or register to vote for this query.

(click on this box to dismiss)

"Good" means "positive score or accepted" "Used sqlfiddle" means just "contains sqlfiddle"

Stack Overflow

Q&A for professional and enthusiast programmers

select
  sqlfiddled,
  total,
  (100 * sqlfiddled / total) percentage
from (select
  sum(case when pa.body like '%sqlfiddle%' then 1 else 0 end) sqlfiddled,
  count(*) as total
  from posts pq
  join posts pa on pq.id = pa.parentid
    and (pa.score > 0 or pq.AcceptedAnswerId = pa.id)
  where pq.creationdate > dateadd(year, -1, getdate())
  and pq.posttypeid = 1
  and pq.tags like '%sql%'
) x

Enter Parameters

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