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


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

  (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 = pa.parentid
    and (pa.score > 0 or pq.AcceptedAnswerId =
  where pq.creationdate > dateadd(year, -1, getdate())
  and pq.posttypeid = 1
  and pq.tags like '%sql%'
) x

Enter Parameters

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