select
  prefecture.pf_code as "都道府県コード",
  prefecture.pf_name as "都道府県名",
  round(
    (hospitalization.inp_yes * 100.0) / (hospitalization.inp_yes + hospitalization.inp_no + hospitalization.unidentified),
    2
  )
  as "入院率"
  
from
  prefecture
  inner join hospitalization
    on prefecture.pf_code = hospitalization.pf_code

order by
  cast(
    round(
      (hospitalization.inp_yes * 100.0) / (hospitalization.inp_yes + hospitalization.inp_no + hospitalization.unidentified),
      2
    )
    as numeric
  ) desc,
  prefecture.pf_code asc