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, 2) as inp_per
    FROM 
        Prefecture P
    INNER JOIN
        Hospitalization H
    ON
        P.pf_code = H.pf_code
)
    ORDER BY
         inp_per DESC
        ,pf_code ASC
    ;