select h.pf_code as 都道府県コード, prefecture.PF_NAME as 都道府県名, (h.inp_yes * 1000 / (h.inp_yes + h.inp_no + h.UNIDENTIFIED) / 10.0) as 入院率
from hospitalization as h
inner join prefecture on h.pf_code = prefecture.pf_code
order by h.inp_yes * 1000 / (h.inp_yes + h.inp_no + h.UNIDENTIFIED) / 10.0 desc,CAST(h.pf_code as int) asc