SELECT
    PF.PF_CODE AS CODE,
    PF.PF_NAME AS NAME,
    ROUND(CASE WHEN DH.TOTAL IS NULL THEN 0 ELSE DH.EVERYDAY_DRINKER * 100.0 / DH.TOTAL END, 1) AS PERCENTAGE
FROM
    PREFECTURE AS PF LEFT JOIN 
    (
        SELECT
            PF_CODE
            ,SUM(CASE WHEN CATEGORY_CODE = '120' AND GENDER_CODE IN ('2', '3') THEN AMT ELSE 0 END) AS EVERYDAY_DRINKER
            ,SUM(CASE WHEN CATEGORY_CODE = '110' AND GENDER_CODE IN ('2', '3') THEN AMT ELSE 0 END) AS TOTAL
        FROM
            DRINK_HABITS
        GROUP BY
            PF_CODE
    ) DH ON PF.PF_CODE = DH.PF_CODE
ORDER BY
    PERCENTAGE desc
    ,CODE desc