SELECT
    PR.PF_CODE as CODE,
    PR.PF_NAME as NAME,
    ROUND((cast(DH3.INSYU as REAL) / cast(DH2.SOUSU as REAL) * 100),1) as PERCENTAGE
FROM
    DRINK_HABITS DH1
LEFT JOIN 
    (
        SELECT
            PF_CODE,
            CATEGORY_CODE,
            SUM(AMT) as SOUSU
        FROM
            DRINK_HABITS
        WHERE
            GENDER_CODE <> '1'
        GROUP BY
            PF_CODE,
            CATEGORY_CODE
    ) DH2
ON 
    DH1.PF_CODE = DH2.PF_CODE
AND DH2.CATEGORY_CODE = '110'
LEFT JOIN 
    (
        SELECT
            PF_CODE,
            CATEGORY_CODE,
            SUM(AMT) as INSYU
        FROM
            DRINK_HABITS
        WHERE
            GENDER_CODE <> '1'
        GROUP BY
            PF_CODE,
            CATEGORY_CODE
    ) DH3
ON 
    DH1.PF_CODE = DH3.PF_CODE
AND DH3.CATEGORY_CODE = '120'
LEFT JOIN
    PREFECTURE PR
ON  
    DH1.PF_CODE = PR.PF_CODE
GROUP BY 
    DH1.PF_CODE
ORDER BY
PERCENTAGE DESC,
DH1.PF_CODE DESC