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) * cast(100 as real), 1) AS "入院率"
from
    HOSPITALIZATION AS h
    INNER JOIN PREFECTURE AS p
        ON p.PF_CODE = h.PF_CODE
order by
    "入院率" desc