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