gistfile1.sql

select
  question_id, cnt, total_cnt, 1.0 * cnt / total_cnt as ratio
  from (
    select question_id, sum(case when correct='f' then 1 else 0 end) as cnt,count(question_id) as total_cnt from quiz_questions group by question_id
  )
order by ratio desc