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