WITH
D1 AS
(SELECT PF_CODE,SUM(AMT) AMT
 FROM DRINK_HABITS
 WHERE GENDER_CODE IN ('2','3')
 AND CATEGORY_CODE = '120'
 GROUP BY PF_CODE
),
D2 AS 
(SELECT PF_CODE,SUM(AMT) AMT
 FROM DRINK_HABITS
 WHERE GENDER_CODE IN ('2','3')
 AND CATEGORY_CODE = '110'
 GROUP BY PF_CODE
)
SELECT
D1.PF_CODE  CODE
,P.PF_NAME  NAME
,ROUND(CAST(D1.AMT AS REAL)/CAST(D2.AMT AS REAL) *100,1) PERCENTAGE
FROM
D1
INNER JOIN
D2
ON D1.PF_CODE = D2.PF_CODE
INNER JOIN
PREFECTURE P
ON D1.PF_CODE = P.PF_CODE
ORDER BY 
3 DESC,1
;