WITH ADMISSION AS (
    SELECT
        PF_CODE,
        ROUND(CAST(INP_YES AS REAL)/(INP_YES + INP_NO + UNIDENTIFIED) *100, 1)
            AS AD_RATE
    FROM
        `HOSPITALIZATION`
)


SELECT
    p.PF_CODE AS '都道府県コード',
    p.PF_NAME AS '都道府県名',
    a.AD_RATE AS '入院率'
FROM
    ADMISSION AS a
    INNER JOIN `PREFECTURE` AS p
    ON a.PF_CODE = p.PF_CODE
ORDER BY
    a.AD_RATE DESC
;