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