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