Guest_imported
New member
- Jan 1, 1970
- 0
1.Calculate max,min,avg,sum unit price in table products.
2.Calculate avg price for beverages.
3.calculate max price for every category.
4.Calculate avg price for every category,display only
those groups which have average more than $30.
5.in result set display productname,unitprice and qty and get
sales amount for each product(tbl order details).Using this
query Create the new one where you calculate sum of sales
amount for each product.
2.Calculate avg price for beverages.
3.calculate max price for every category.
4.Calculate avg price for every category,display only
those groups which have average more than $30.
5.in result set display productname,unitprice and qty and get
sales amount for each product(tbl order details).Using this
query Create the new one where you calculate sum of sales
amount for each product.