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