SELECT
    PR.PF_CODE as CODE,
    PR.PF_NAME as NAME,
    ROUND((cast(SUM(DH.AMT) as REAL) / cast(SUM(AL.SOSU) as REAL) * 100),1) as PERCENTAGE
FROM 
    DRINK_HABITS DH,
    (
        SELECT PF_CODE,SUM(AMT) as SOSU
        FROM DRINK_HABITS
        WHERE CATEGORY_CODE = '110'
        AND GENDER_CODE <> '1'
        GROUP BY
        PF_CODE
    ) AL,
    PREFECTURE PR
WHERE
    DH.PF_CODE = PR.PF_CODE
AND DH.PF_CODE = AL.PF_CODE
AND DH.CATEGORY_CODE = '120'
AND DH.GENDER_CODE <> '1'
GROUP BY
    PR.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    PR.PF_CODE DESC