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