SELECT
pr.pf_code as 都道府県コード
,pr.pf_name as 都道府県名
,ho.inp_yes * 100 / (ho.inp_yes + ho.inp_no + ho.unidentified) as 入院率

FROM hospitalization ho
 left outer join prefecture pr
 on ho.pf_code = pr.pf_code
ORDER BY 入院率 asc
,都道府県コード desc
;