Find Product name and total quantity of products ordered. Only show total for which the .1 .quantity ordered is less than 100 Product Name Mishi Kobe Niku, TotalQuantities=95 O Product Name Northwind Traders Marmalade ,TotalQuantities 99 Product Name - Northwind Traders Coffee TotalQuantities. 95 Product Name Northwind Traders Olive Oil, Totalquantities 85 Product Name- Mishi Kobe Niku , Totalquantities. 95 Product Name Northwind Traders Olive on TotalQuantities 85 o
Consider the following part of the Northwind database Relational Schema Order Details (OrderID, ProductID, Quantity , UnitPrice) Products (ProductID, ProductName, UnitPrice, CategoryID, SupplierID) Employees (EmployeeID ,FirstName, LastName, Title City)
Find Product name and total quantity of products ordered. Only show total for which the .1 .quantity ordered is less tha
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Find Product name and total quantity of products ordered. Only show total for which the .1 .quantity ordered is less tha
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!