SELECT
    H.PF_CODE AS "都道府県コード"
    ,P.PF_NAME AS "都道府県名"
    ,ROUND(CAST(INP_YES AS Float)/(CAST(INP_YES AS Float)+CAST(INP_NO AS Float)+CAST(UNIDENTIFIED AS Float))*100,1) AS "入院率"
FROM
    HOSPITALIZATION AS H
LEFT JOIN PREFECTURE AS P
ON H.PF_CODE = P.PF_CODE
GROUP BY
    H.PF_CODE
ORDER BY
    "入院率" desc
    ,"都道府県コード"