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