SELECT
    DH.PF_CODE AS [CODE]
    , PF.PF_NAME AS [NAME]
    --都道府県毎の毎日飲酒率
    , ROUND( 
    	--毎日飲酒人数
        100.0 * SUM( 
            CASE DH.CATEGORY_CODE 
                WHEN '120' THEN DH.AMT 
                ELSE 0 
                END
        ) / SUM( --総調査人数
            CASE DH.CATEGORY_CODE 
                WHEN '110' THEN DH.AMT 
                ELSE 0 
                END
        )
        --小数点第2を四捨五入
        , 1
    ) AS [PERCENTAGE]
FROM
    DRINK_HABITS AS [DH] 
    INNER JOIN PREFECTURE AS [PF] 
        ON PF.PF_CODE = DH.PF_CODE 
WHERE
    DH.GENDER_CODE IN ('2', '3') 
GROUP BY
    DH.PF_CODE 
ORDER BY
    PERCENTAGE desc
    , DH.PF_CODE desc;