/*
    毎日飲酒人数→カテゴリコード：120かつ性別コード2,3の合計
    総調査人数→性別コード2,3の合計

*/

SELECT
    D.PF_CODE AS CODE,
    P.PF_NAME AS NAME,
    ROUND(CAST(SUM(CASE D.CATEGORY_CODE WHEN 120 THEN D.AMT END) AS REAL) /
    CAST(SUM(D.AMT) AS REAL) * 100, 1) AS PERCENTAGE
FROM
    DRINK_HABITS AS D
INNER JOIN
    PREFECTURE AS P
ON
    D.PF_CODE = P.PF_CODE
WHERE
    D.GENDER_CODE > 1
GROUP BY
    D.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    CODE DESC;