Question: Create SQL using table : Customer (CustID, CustName, City) Category (CatID, CatName, Description) Employee (EmpID, LName, FName, BirthDate) Order (OrderID, CustID, EmpID, OrderDate, ShipperID) OrderDetail
| Create SQL using table :
Customer (CustID, CustName, City)
Category (CatID, CatName, Description)
Employee (EmpID, LName, FName, BirthDate)
Order (OrderID, CustID, EmpID, OrderDate, ShipperID)
OrderDetail (OdID, OrderID, ProdID, Qty)
Product (ProdID, ProdName, SupplierID, CatID, Unit, Price)
Shipper (ShipperID, ShipperName, Phone)
Supplier (SupplierID, SupplierName, ContactName, City, Phone) |
1) List product name with its total order quantity, include the product even it has no orders.
2) List every product name that has a total sales amount greater than $1000.
3) List the name of product category and total sales amount in each category for orders created in February 2021.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
