SELECT
    hs.pf_code as "都道府県コード",
    pf.pf_name as "都道府県名",
    ROUND(
        CAST(hs.inp_yes as real) / 
        CAST((hs.inp_yes + hs.inp_no + hs.unidentified) as real)
        *100
        , 1) as "入院率"

FROM HOSPITALIZATION AS hs
INNER JOIN PREFECTURE as pf
ON hs.pf_code = pf.pf_code
ORDER BY
    "入院率" DESC,
    hs.pf_code ASC