select 
pf_code as '都道府県コード'
, (select pf_name from prefecture where pf_code=hospitalization.pf_code) as '都道府県名'
, round((cast(inp_yes as real) /(cast(inp_yes as real)+cast(inp_no as real) +cast(unidentified as real))) * 1000)/ 10 as '入院率'
from hospitalization
order by 3 desc, 1 asc;