select
  prefecture.PF_CODE as 都道府県コード,
  pf_name as 都道府県名,
  round((cast(sum(inp_yes) as REAL)) / cast(sum(inp_yes + inp_no + unidentified) as REAL) * 100, 1) as 入院率
from prefecture
join hospitalization
on prefecture.pf_code = hospitalization.pf_code
group by prefecture.PF_CODE, pf_name
order by
    入院率 desc, prefecture.pf_code asc;