SELECT 
PREFECTURE.PF_CODE AS CODE,
PREFECTURE.PF_NAME AS NAME,
ROUND(
(SELECT sum(DRINK_HABITS.AMT)
FROM DRINK_HABITS 
INNER JOIN PREFECTURE
ON DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
WHERE
DRINK_HABITS.CATEGORY_CODE = '120'
AND DRINK_HABITS.GENDER_CODE IN ('2','3')
GROUP BY DRINK_HABITS.PF_CODE)
/
(SELECT sum(DRINK_HABITS.AMT)
FROM DRINK_HABITS 
INNER JOIN PREFECTURE
ON DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
WHERE
DRINK_HABITS.GENDER_CODE IN ('2','3')
GROUP BY DRINK_HABITS.PF_CODE)
*100,2)AS PERCENTAGE
FROM
DRINK_HABITS 
INNER JOIN PREFECTURE
ON DRINK_HABITS.PF_CODE = PREFECTURE.PF_CODE
ORDER BY
PERCENTAGE ASC
;