select
cast(hospitalization.pf_code as integer) as '都道府県コード',
prefecture.pf_name as '都道府県名',
round((100.0 * inp_yes) / (inp_yes + inp_no + unidentified)) as '入院率'
from hospitalization
inner join prefecture on prefecture.pf_code = hospitalization.pf_code
order by 入院率 desc, 都道府県コード asc;