with ratio_cte as (
  select
    PF_CODE,
    round(cast(INP_YES as real) / (INP_YES + INP_NO + UNIDENTIFIED) * 1000) / 10 as INP_RATIO
  from
    HOSPITALIZATION
  group by
    PF_CODE
)
select
  ratio_cte.PF_CODE as "都道府県コード",
  PREFECTURE.PF_NAME as "都道府県名",
  ratio_cte.INP_RATIO as "入院率"
from
  ratio_cte
inner join
  PREFECTURE
  on PREFECTURE.PF_CODE = ratio_cte.PF_CODE
order by
  ratio_cte.INP_RATIO desc, ratio_cte.PF_CODE