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