SELECT
    h.PF_CODE as 都道府県コード
    , p.PF_NAME as 都道府県名
    , ROUND(100 * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED),2) as 入院率
FROM
    (
    SELECT
        CAST(PF_CODE AS INTEGER) as PF_CODE
        , CAST(INP_YES AS FLOAT) as INP_YES
        , CAST(INP_NO AS FLOAT) as INP_NO
        , CAST(UNIDENTIFIED AS FLOAT) as UNIDENTIFIED
    FROM
        HOSPITALIZATION
    ) as h

-- 県名をjoin
LEFT JOIN
        PREFECTURE as p
    ON
        h.PF_CODE = p.PF_CODE

ORDER BY
    入院率 DESC
    , 都道府県コード ASC
;