SELECT pf_code AS CODE, pf_name AS NAME, ROUND(SUM(CASE category_code WHEN 120 THEN amt END)* 100.0 / SUM(CASE category_code WHEN 110 THEN amt END), 1) AS PERCENTAGE FROM drink_habits JOIN prefecture USING (pf_code) WHERE gender_code IN (2,3) GROUP BY pf_code ORDER BY 3 DESC, 1 DESC;