SELECT
     H.PF_CODE AS '都道府県コード'
    ,P.PF_NAME AS '都道府県名'
    ,H.入院率
FROM
(
    SELECT
         H.PF_CODE
        ,ROUND((H.INP_YES * 100.0) / (INP_YES + INP_NO + UNIDENTIFIED), 1) AS '入院率'
    FROM
        HOSPITALIZATION AS H
) AS H
INNER JOIN
    PREFECTURE AS P
ON
    P.PF_CODE = H.PF_CODE
ORDER BY
     H.入院率 DESC
    ,H.PF_CODE ASC