SELECT 
  A.PF_CODE  AS CODE,
  PF_NAME   AS NAME,
  (
CAST(
  (
  
  
  (
  1000 *
  (SELECT SUM(AMT) FROM DRINK_HABITS AS C WHERE A.PF_CODE = C.PF_CODE AND CATEGORY_CODE = '120')
    / (SELECT SUM(AMT) FROM DRINK_HABITS AS D WHERE A.PF_CODE = D.PF_CODE AND CATEGORY_CODE = '110')
   ) 
    ) / 10
    
    AS REAL)
    ) AS PERCENTAGE
FROM 
  DRINK_HABITS AS A
INNER JOIN PREFECTURE AS B ON A.PF_CODE =  B.PF_CODE  
WHERE 
  GENDER_CODE IN ('2', '3') AND CATEGORY_CODE != '130'
GROUP BY A.PF_CODE
ORDER BY PERCENTAGE DESC, A.PF_CODE ASC