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
        , '都道府県コード'
    ;