SELECT
    H.PF_CODE AS '都道府県コード',
    P.PF_NAME AS '都道府県名',
    round(cast(H.INP_YES as REAL) / cast(H.INP_YES + H.INP_NO + H.UNIDENTIFIED as REAL) * 100, 1) AS '入院率'
FROM HOSPITALIZATION AS H
    LEFT JOIN PREFECTURE AS P ON H.PF_CODE = P.PF_CODE
ORDER BY `入院率` DESC, `都道府県コード` ASC