SELECT
pr.pf_code AS 都道府県コード
,pr.pf_name AS 都道府県名
,ROUND(CAST(ho.inp_yes AS REAL) / (CAST(ho.inp_yes AS REAL) + CAST(ho.inp_no AS REAL) + CAST(ho.unidentified AS REAL)) , 1 ) AS 入院率

FROM hospitalization ho
 left outer join prefecture pr
 on ho.pf_code = pr.pf_code

ORDER BY 入院率 asc
,pr.pf_code desc
;