SELECT DH2.PF_CODE AS CODE
	,PR.PF_NAME AS NAME
	,SUB1.DH1_AMT
	,DH2.CATEGORY_CODE
  FROM (SELECT DH1.PF_CODE AS DH1_CODE , DH1.AMT AS DH1_AMT FROM DRINK_HABITS AS DH1 WHERE DH1.CATEGORY_CODE = '120' GROUP BY DH1.PF_CODE)
    AS SUB1
    INNER JOIN  
  DRINK_HABITS AS DH2
    ON SUB1.DH1_CODE = DH2.PF_CODE
	 INNER JOIN PREFECTURE AS PR
		    ON DH2.PF_CODE = PR.PF_CODE
    WHERE DH2.CATEGORY_CODE != '130'


--SELECT DH2.PF_CODE AS CODE , PR.PF_NAME AS NAME FROM DRINK_HABITS AS DH2 INNER JOIN PREFECTURE AS PR ON DH2.PF_CODE = PR.PF_CODE

--SELECT DH1.PF_CODE AS DH1_CODE , DH1.AMT DH1_AMT FROM DRINK_HABITS AS DH1 WHERE DH1.CATEGORY_CODE = '120' GROUP BY DH1.PF_CODE