SELECT
 pre.PF_CODE as CODE
 ,PF_NAME as NAME
 ,ROUND(
  SUM(CASE WHEN CATEGORY_CODE = '120' THEN CAST(AMT as REAL) ELSE 0 END) / SUM(CASE WHEN CATEGORY_CODE = '110' THEN CAST(AMT as REAL) ELSE 0 END) * 100
  ,1) as PERCENTAGE
FROM 
 PREFECTURE pre
INNER JOIN DRINK_HABITS dri
 ON pre.PF_CODE = dri.PF_CODE
WHERE 
 GENDER_CODE = '2' OR GENDER_CODE = '3'
GROUP BY 
 CODE,NAME
ORDER BY 
 PERCENTAGE desc, pre.PF_CODE desc;