select
h.PF_CODE as "都道府県コード",
p.PF_NAME as "都道府県名",
ROUND(cast(h.inp_yes as REAL)/( cast(h.inp_yes as REAL) + cast(h.inp_no as REAL) + cast(h.unidentified as REAL) ) * 100, 1) as "入院率"
from  hospitalization as h
inner join prefecture as p on p.pf_code = h.pf_code
order by "入院率" desc, h.pf_code asc