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