select pf_code as 都道府県コード, pf_name as 都道府県名, round(cast(inp_yes as double) / (inp_yes + inp_no + unidentified) * 100, 1) as 入院率
from hospitalization join prefecture using(pf_code)
order by 入院率 desc, pf_code