SELECT pf_code AS '都道府県コード', pf_name '都道府県名', inp_per '入院率'
                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
                    ;