578. Get Highest Answer Rate Question

SELECT question_id

FROM [survey_log]

group by question_id

order by sum(case when action = 'answer' then 1 end)/cast(sum(case when action = 'show' then 1 end) as float) desc

limit 1;