Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
1 Select from Products 2 Select Name Phone from Customers where A...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started