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