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 HOSPITALIZATION AS hos
JOIN PREFECTURE AS pre
ON pre.PF_CODE = hos.PF_CODE
ORDER BY 入院率 DESC
    , hos.PF_CODE;