SELECT
    t.pf_code as "都道府県コード",
    t.pf_name as "都道府県名",
    case when t.rate = CAST(t.rate as int) THEN CAST(t.rate as int)
    else t.rate
    end as "入院率"

FROM
(
SELECT
    hs.pf_code,
    pf.pf_name,
    ROUND(hs.inp_yes / hs.inp_yes + hs.inp_no + hs.unidentified * 100, 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