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