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