select
    h.PF_CODE as 都道府県コード
    ,PF_NAME as 都道府県名
    ,round(100.0 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) as 入院率
from
    HOSPITALIZATION as h
    inner join PREFECTURE as p
        on h.PF_CODE = p.PF_CODE 
order by
    入院率 desc
    ,h.PF_CODE