11. Display a report containing the product ID and the total cost of products for the product ID whose total cost is more than $ 10,000. (Use the AdventureWorks database)
select ProductID,sum(LineTotal) as Total from sales.salesorderDetail Group by productID Having sum(LineTotal)>10000
No comments:
Post a Comment