SELECT LGBRAND.BRAND_ID,LGBRAND.BRAND_NAME,AVG(LGPRODUCT.PROD_PRICE)AS AVGER FROM LGPRODUCT,LGBRAND WHERE LGPRODUCT.BRAND_ID = LGBRAND.BRAND_ID ORDER BY BRAND_NAME;
SELECT LGBRAND.BRAND_ID,LGBRAND WHERE LGPRODUCT.BRAND_ID = LGBRAND.BRAND_ID GROUP BY LGBRAND.BRAND_ID,LGBRAND.BRAND_NAME ORDER BY BRAND_NAME
