select
    a.PF_CODE as '都道府県コード'
    , b.PF_NAME as '都道府県名'
    , round(cast(a.INP_YES as double) / cast((a.INP_YES + a.INP_NO + a.UNIDENTIFIED) as double) * 100, 1) as '入院率'
from
    HOSPITALIZATION a
    inner join PREFECTURE b
        on a.PF_CODE = b.PF_CODE
order by
    3 desc
    , 1 asc