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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!