SELECT P.pf_code as '都道府県コード', P.pf_name AS '都道府県名'
    ,CAST( round( cast(H.inp_yes as real) / cast ((H.inp_yes + H.inp_no + H.UNIDENTIFIED) as real) * 100, 2) as INTEGER) as '入院率'
FROM 
    Prefecture P
INNER JOIN
    Hospitalization H
ON
    P.pf_code = H.pf_code
ORDER BY
    3 DESC
;