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) ) / SUM (CAST((H.inp_yes + H.inp_no + 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
        ;