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