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

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

ORDER BY 入院率 DESC
,pr.pf_code ASC
;