select
    a.PF_CODE     as 都道府県コード
    ,b.PF_NAME    as 都道府県名
    ,round((a.INP_YES/(a.INP_YES + a.INP_NO + a.UNIDENTIFIED))*100,1)  as 入院率
from
    HOSPITALIZATION a
    ,PREFECTURE b
where 1=1
    and a.PF_CODE = b.PF_CODE
order by
    入院率  desc