Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions

Question

TEENAGE DRIVERS ARE MORE LIKELY TO BE INVOLVED IN A CRASH WHEN:

Answered: 1 week ago

Question

Demonstrate each of the anomaly types with an example.

Answered: 1 week ago