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