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