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