select
    pref.pf_code as 都道府県コード,
    pref.pf_name as 都道府県名,
    round(
        (
            cast(hosp.inp_yes as real)
            / (hosp.inp_yes + hosp.inp_no + hosp.unidentified)
            * 100
        ),
        1
    ) as 入院率
from
    prefecture as pref
    inner join hospitalization as hosp
        on pref.pf_code = hosp.pf_code
order by
    入院率 desc,
    pref.pf_code asc
;