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