select
t1.PF_CODE as 都道府県コード
, t2.PF_NAME as 都道府県名
, round((cast(t1.inp_yes as float) / (t1.INP_YES + t1.INP_NO + t1.UNIDENTIFIED) * 100 ),1) as 入院率
from HOSPITALIZATION as t1
left outer join
PREFECTURE as t2
on t1.pf_code = t2.pf_code
order by 入院率 desc, 都道府県コード asc