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