SELECT
    H.PF_CODE AS 都道府県コード,
    P.PF_NAME AS 都道府県名,
    ROUND(CAST(H.INP_YES AS float) * 100 / (H.INP_YES + H.INP_NO + H.UNIDENTIFIED),1) AS 入院率
FROM
    HOSPITALIZATION AS H INNER JOIN PREFECTURE AS P
    ON H.PF_CODE = P.PF_CODE
ORDER BY 入院率 DESC, 都道府県コード