SELECT
    hos.pf_code AS '都道府県コード',
    pre.pf_name AS '都道府県名',
    ROUND(CAST(hos.inp_yes AS REAL) / CAST(hos.inp_yes + hos.inp_no + hos.unidentified AS REAL) * 100, 1) AS '入院率'
FROM
    hospitalization AS hos
        INNER JOIN prefecture AS pre
            ON hos.pf_code = pre.pf_code
ORDER BY
    ROUND(CAST(hos.inp_yes AS REAL) / CAST(hos.inp_yes + hos.inp_no + hos.unidentified AS REAL) * 100, 1) DESC,
    hos.pf_code;