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