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