select 
    PRF.PF_CODE as "都道府県コード"
    , PRF.PF_NAME as "都道府県名"
    , round(
        cast(HSP.INP_YES as real) 
        / cast((HSP.INP_YES + HSP.INP_NO + HSP.UNIDENTIFIED) as real)
        * 100
    , 1) as "入院率"

from
    HOSPITALIZATION as HSP
join
    PREFECTURE as PRF on HSP.PF_CODE = PRF.PF_CODE
order by
    "入院率" desc
    , "都道府県コード" asc
;