WITH
A   AS
(
SELECT
    D.PF_CODE
,   SUM(CASE WHEN D.CATEGORY_CODE = '110' THEN D.AMT ELSE 0 END)    AS denominator
,   SUM(CASE WHEN D.CATEGORY_CODE = '120' THEN D.AMT ELSE 0 END)    AS numerator
FROM
    DRINK_HABITS    D
WHERE
    D.CATEGORY_CODE IN ('110','120')
AND D.GENDER_CODE   IN ('2','3')
GROUP BY
    D.PF_CODE
)
SELECT
    A.PF_CODE                                   AS CODE
,   P.PF_NAME                                   AS NAME
,   ROUND(CAST(A.numerator AS REAL) * 100 / CAST(A.denominator AS REAL),1)  AS PERCENTAGE
FROM
    A,
    PREFECTURE      P
WHERE
    A.PF_CODE   =   P.PF_CODE
ORDER BY
    ROUND(CAST(A.numerator AS REAL) * 100 / CAST(A.denominator AS REAL),1) DESC
,   A.PF_CODE DESC