with master as(select pf_code
, round(cast(inp_yes as real)*100 / (cast(inp_yes as real) +cast(inp_no as real)+cast(unidentified as real)),1) as ratio
from hospitalization
order by 2 desc)

select m.pf_code as 都道府県コード
, p.pf_name as 都道府県名
, m.ratio as 入院率
from master as m
left join prefecture as p
using(pf_code)
order by 1