HELP NOOB! Easy question

[SigmaBlu]

Which city/state offers the most products?

Close but no cigar......
SELECT Max(PROD.Volume) AS CITY_STATE_MAX_VOL, MNF.STATE
FROM MNF INNER JOIN PROD ON MNF.Brand = PROD.Brand
GROUP BY MNF.STATE;


wtf im i doing wrong
please help. and tell me why my logic didnt have the correct result.


PRODBrandTypeCostVolumeAnheuser-BuschBeer$17.50360BeringerWine$7.9945CokeSoda$4.29144CoorsBeer$16.50360E_J_GalloCooler$15.0070E_J_GalloWine$9.99128EverclearGrain$29.9964Jack_DanielsWhiskey$17.9955Jim_BeanWhiskey$19.9950MillerBeer$19.00360PepsiSoda$3.99144PepsiWater$3.49240




MNFBrandCityStateAnheuser-BushSt_LouisMOBeringerSt_HelenaCACokeAtlantaGACoorsDenverCOE_J_GalloNapaCAEverclearSt_LouisMOJack_DanielsLynchburgKYJim_BeanBostonTNMillerMilwaukeeWIPepsiPurchaseNY


BEVTypeProofCarbonatedBeer20YCooler25YGrain190NSoda0YWater0NWhiskey80NWine30N

[SigmaBlu]

lets try this again
Which city and states offer the most products?

my answer:

SELECT Max(PROD.Volume) AS CITY_STATE_MAX_VOL, MNF.STATE
FROM MNF INNER JOIN PROD ON MNF.Brand = PROD.Brand
GROUP BY MNF.STATE;

PRODBrandTypeCostVolumeAnheuser-BuschBeer$17.50360BeringerWine$7.9945CokeSoda$4.29144CoorsBeer$16.50360E_J_GalloCooler$15.0070E_J_GalloWine$9.99128EverclearGrain$29.9964Jack_DanielsWhiskey$17.9955Jim_BeanWhiskey$19.9950MillerBeer$19.00360PepsiSoda$3.99144PepsiWater$3.49240

MNFBrandCityStateAnheuser-BushSt_LouisMOBeringerSt_HelenaCACokeAtlantaGACoorsDenverCOE_J_GalloNapaCAEverclearSt_LouisMOJack_DanielsLynchburgKYJim_BeanBostonTNMillerMilwaukeeWIPepsiPurchaseNY

 
 
BEVTypeProofCarbonatedBeer20YCooler25YGrain190NSoda0YWater0NWhiskey80NWine30N