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