SELECT
    hospitalization.pf_code AS '都道府県コード',
    pf_name AS '都道府県名',
    round(
        cast(inp_yes AS real) / cast((inp_yes + inp_no + UNIDENTIFIED) AS real) * 100.0,
        1
    ) AS '入院率'
FROM
    hospitalization
    INNER JOIN prefecture ON hospitalization.pf_code = prefecture.pf_code
ORDER BY
    `入院率` DESC,
    hospitalization.pf_code asc