select
    P.PF_CODE   as "都道府県コード"
,   P.PF_NAME   as "都道府県名"
,   ROUND((CAST(H.INP_YES AS REAL) * 100) / CAST(H.INP_YES + H.INP_NO + H.UNIDENTIFIED AS REAL) ,1) as "入院率"
from
    HOSPITALIZATION H
    inner join
    PREFECTURE      P
    on
    H.PF_CODE       = P.PF_CODE
order by
    "入院率" desc
,   P.PF_CODE asc