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