Using database ProductOrders as following: Products Customers Column Name Condensed Type Column Name Condensed Type nvarchar(5)...

Transcribed Image Text:

Using database "ProductOrders" as following: Products Customers Column Name Condensed Type Column Name Condensed Type nvarchar(5) nvarchar (30) * ProductCode Y CustomerID nvarchar(5) Name Name nvarchar(30) Price float Address nvarchar (50) StockQuantity int Phone nvarchar(10) Email nvarchar(30) OrderItems Orders Column Name Condensed Type Column Name Condensed Type Y OrderID * ProductCode nvarchar(10) 8 OrderID nvarchar(10) nyarchar(5) Date date Quantity int Customer ID nvarchar (5) Discount float Amount float SelPrice float I. Simple SQL queries: In the database "ProductOrders" created in the previous exercise, write the following queries: 1. Find all Products in the database 2. Find the name and the phone number of all customers who live in 'BINH CHANH' 3. Show the Name, Price, StockQuantity and Amount (which is equal to StockQuantity * Price) of all Products having Amount < 20000. 4. Find all customers who lives in 'BINH CHANH' or 'TAN BINH' 5. Find all Products having 10<= Price <= 45 6. Find all customers who have a phone number. 7. Find months and years in which customer 'C01' made at least an order. 8. Find all customers whose name begin with 'TRAN '. 9. Find all LCD monitor products. 10. Find the CustomerlID of all customer who made orders in May 2000. 11. List all Products by descending order of Price. 12. List all customer by descending order of Address, with customers having same address we order by ascending order of Name. 13. Find the product with the highest Price. Using database "ProductOrders" as following: Products Customers Column Name Condensed Type Column Name Condensed Type nvarchar(5) nvarchar (30) * ProductCode Y CustomerID nvarchar(5) Name Name nvarchar(30) Price float Address nvarchar (50) StockQuantity int Phone nvarchar(10) Email nvarchar(30) OrderItems Orders Column Name Condensed Type Column Name Condensed Type Y OrderID * ProductCode nvarchar(10) 8 OrderID nvarchar(10) nyarchar(5) Date date Quantity int Customer ID nvarchar (5) Discount float Amount float SelPrice float I. Simple SQL queries: In the database "ProductOrders" created in the previous exercise, write the following queries: 1. Find all Products in the database 2. Find the name and the phone number of all customers who live in 'BINH CHANH' 3. Show the Name, Price, StockQuantity and Amount (which is equal to StockQuantity * Price) of all Products having Amount < 20000. 4. Find all customers who lives in 'BINH CHANH' or 'TAN BINH' 5. Find all Products having 10<= Price <= 45 6. Find all customers who have a phone number. 7. Find months and years in which customer 'C01' made at least an order. 8. Find all customers whose name begin with 'TRAN '. 9. Find all LCD monitor products. 10. Find the CustomerlID of all customer who made orders in May 2000. 11. List all Products by descending order of Price. 12. List all customer by descending order of Address, with customers having same address we order by ascending order of Name. 13. Find the product with the highest Price.

Answer rating: 100% (QA)

1 Select from Products 2 Select Name Phone from Customers where A... View the full answer