pls help with sql queries thanks! Create a view “vwSummary” that summarizes all quantity and sales by productcode, produ
Posted: Mon Jul 11, 2022 9:49 am
pls help with sql queries thanks!
Create a view “vwSummary” that summarizes all quantity and sales by productcode, productname, customername, city, state, postalcode, Year and price:
Show me the Total number of products ordered by productname.: the output should be ProductCode, productName , TotalOdered.
Show me the total sales for each year ordered by the most sales to least sales. Out column should have saleYear, and sale.
Show me the products and revenue ordered by the most revenue to the least. out: column ProductCode, ProductName, Sale
Create a view “vwSummary” that summarizes all quantity and sales by productcode, productname, customername, city, state, postalcode, Year and price:
Show me the Total number of products ordered by productname.: the output should be ProductCode, productName , TotalOdered.
Show me the total sales for each year ordered by the most sales to least sales. Out column should have saleYear, and sale.
Show me the products and revenue ordered by the most revenue to the least. out: column ProductCode, ProductName, Sale