SELECT 
PF_CODE [都道府県コード]
,PF_NAME [都道府県名]
,val [入院率]
FROM
(
    select 
    a.PF_CODE
    ,b.PF_NAME
    ,ROUND(100*CAST(INP_YES as real)/CAST(INP_YES+INP_NO+UNIDENTIFIED as real),1) val
    FROM HOSPITALIZATION a
    INNER JOIN
    (
    select *
    from PREFECTURE
    ) b
    ON
    a.PF_CODE = b.PF_CODE
)c
ORDER BY 
val desc
,PF_CODE