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