SELECT 
    PRE.PF_CODE AS `都道府県コード`
    ,PRE.PF_NAME AS `都道府県名`
    ,ROUND(CAST(SUM(INP_YES) AS REAL) / CAST((SUM(INP_YES) + SUM(INP_NO) + SUM(UNIDENTIFIED)) AS REAL) * 100, 1) AS `入院率`
FROM HOSPITALIZATION AS HO
INNER JOIN PREFECTURE AS PRE
        ON HO.PF_CODE = PRE.PF_CODE
GROUP BY PRE.PF_CODE,PRE.PF_NAME
ORDER BY `入院率` DESC