SELECT
    H.PF_CODE AS '都道府県コード',
    P.PF_NAME AS '都道府県名',
    ROUND(
        CAST(INP_YES AS REAL)/
        CAST(INP_YES+INP_NO+UNIDENTIFIED AS REAL)*100
        ,1) AS '入院率'
FROM
    HOSPITALIZATION AS H
    INNER JOIN PREFECTURE AS P
        ON P.PF_CODE = H.PF_CODE
ORDER BY
    入院率 DESC,
    都道府県コード ASC
    ;