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