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