SELECT PREF.PF_CODE CODE, PREF.PF_NAME NAME,
	ROUND(PREF1.SAKENOMI/PREF2.TOTAL*100,2) PARCENTAGE
FROM PREFECTURE PREF
	LEFT JOIN
		(
			SELECT PF_CODE, COUNT(*) SAKENOMI
			FROM DRINK_HABITS
			WHERE GENDER_CODE IN ('2','3')
				AND CATEGORY_CODE = '110'
		) PREF1
		ON PREF.PF_CODE = PREF1.PF_CODE
		
	CROSS JOIN (SELECT COUNT(*) TOTAL FROM DRINK_HABITS) PREF2
ORDER BY ROUND(PREF1.SAKENOMI/PREF2.TOTAL*100,2) DESC, PREF.PF_CODE DESC