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