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