Question: DATABASE Using database ProductOrders as following: Products Column Name 9 Product Code Name Price StockQuantity Condensed Type nvarchar(5) nvarchar(30) float Customers Column Name Customer ID

DATABASE DATABASE Using database "ProductOrders" as

Using database "ProductOrders" as following: Products Column Name 9 Product Code Name Price StockQuantity Condensed Type nvarchar(5) nvarchar(30) float Customers Column Name Customer ID Name Address Phone Email Condensed Type nvarchar(5) nvarchar(30) nvarchar(50) nvarchar(10) nvarchar(30) int Order Items Column Name 9 Order ID 8 ProductCode Quantity Discount SellPrice Condensed Type nvarchar(10) nvarchar(5) int float float Orders Column Name 9 Order ID Date Condensed Type nvarchar(10) date nvarchar(5) float Customer ID Amount 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

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 General Management Questions!