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