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