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