SELECT
    t.pf_code as "都道府県コード",
    t.pf_name as "都道府県名",
    t.rate as "入院率"

FROM
(
SELECT
    hs.pf_code,
    pf.pf_name,
    ROUND((hs.inp_yes * 100) / (hs.inp_yes + hs.inp_no + hs.unidentified), 2) as rate

FROM HOSPITALIZATION AS hs
INNER JOIN PREFECTURE as pf
ON hs.pf_code = pf.pf_code
) as t
ORDER BY
    t.rate DESC,
    t.pf_code ASC