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