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