Question: 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

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
Step by Step Solution
3.62 Rating (159 Votes )
There are 3 Steps involved in it
1 Select from Products 2 Select Name Phone from Customers where A... View full answer
Get step-by-step solutions from verified subject matter experts
