pls help with sql queries thanks! Create a view “vwSummary” that summarizes all quantity and sales by productcode, produ

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

pls help with sql queries thanks! Create a view “vwSummary” that summarizes all quantity and sales by productcode, produ

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”