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