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
    left join PREFECTURE
    on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by round(cast(INP_YES as real)/cast((INP_YES + INP_NO + UNIDENTIFIED) as real) * 100,1) desc
,HOSPITALIZATION.PF_CODE