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