select p.pf_code as 都道府県コード, p.pf_name as 都道府県名, round(cast(h.yes as real)/cast(h.total as real)*100,2) as 入院率
from(
select pf_code, sum(inp_yes) as yes, sum(inp_yes)+sum(inp_no)+sum(unidentified) as total
from hospitalization
group by pf_code
) as h left join prefecture as p
on h.pf_code = p.pf_code
order by 3 desc, 1