select 
  t1.PF_CODE as 都道府県コード, 
  t2.PF_NAME as 都道府県名, 
  round(
    (cast(INP_YES as real) / 
    cast((INP_YES + INP_NO + UNIDENTIFIED) as real)) * 100, 
  1) as 入院率
from HOSPITALIZATION as t1 
inner join PREFECTURE as t2
on t1.PF_CODE = t2.PF_CODE
order by 入院率 desc, cast(都道府県コード as int) asc
;