SELECT
    h.PF_CODE as 都道府県コード,
    p.PF_NAME as 都道府県名,
    ROUND(
        CAST(INP_YES as FLOAT) / (CAST(INP_YES as FLOAT) + CAST(INP_NO as FLOAT) + CAST(UNIDENTIFIED as FLOAT))*100, 1
    ) as 入院率
FROM
    HOSPITALIZATION as h
    INNER JOIN PREFECTURE as p
        ON p.PF_CODE = h.PF_CODE
ORDER BY 入院率 DESC,
    h.PF_CODE ASC