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