WITH SUM_HOSPI AS(
    SELECT
        PF_CODE,
        INP_YES,
        INP_YES+INP_NO+UNIDENTIFIED AS SUM_INP
    FROM
        HOSPITALIZATION
)
SELECT
    t1.PF_CODE AS "都道府県コード",
    t2.PF_NAME AS "都道府県名",
    ROUND(CAST(t1.INP_YES AS real)/t1.SUM_INP,1)*100 AS "入院率"
FROM
    SUM_HOSPI AS t1
LEFT JOIN PREFECTURE AS t2
    ON t1.PF_CODE = t2.PF_CODE
ORDER BY
    3 DESC,
    1
;