SELECT
    h.PF_CODE as 都道府県コード,
    p.PF_NAME as 都道府県名,
    ROUND(100.0 * h.INP_YES / (h.INP_YES + h.INP_NO + h.UNIDENTIFIED), 2) as 入院率
FROM
    (
    SELECT
        CAST(PF_CODE AS INTEGER) as PF_CODE,
        CAST(INP_YES AS REAL) as INP_YES,
        CAST(INP_NO AS REAL) as INP_NO,
        CAST(UNIDENTIFIED AS REAL) as UNIDENTIFIED
    FROM
        HOSPITALIZATION
    ) as h
LEFT JOIN
    PREFECTURE as p
ON
    h.PF_CODE = p.PF_CODE
ORDER BY
    入院率 DESC,
    都道府県コード ASC
;