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