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( cast(H.inp_yes as real)  / (CAST( H.inp_yes + H.inp_no + H.UNIDENTIFIED as real) ) * 100, 1) 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
                ;