Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

III. SubQueries in SQL: In the database ProductOrders created in the previous exercise, write the following queries using subqueries: 1. List all products having

III. SubQueries in SQL: In the database "ProductOrders" created in the previous exercise, write the following queries using subqueries: 1. List all products having Price smaller than the price of product 'P05' 2. List all customers who have made an order by using EXISTS in WHERE clause. 3. List all customers who have never made an order by using NOT EXISTS in WHERE clause 4. List all customers who have made an order by using IN in WHERE clause. 5. List all customers who have never made an order by using NOT IN in WHERE clause 6. List all products bought in order 'Or002' 7. List all products having Price greater than all the prices of 'Keyboard' and 'Mouse' 8. List all products having price greater than the prices 'Keyboard' or 'Mouse' 9. List all products which have been bought by customer 'NGUYEN THI BE' (Nguyn Th B). 10. List all products having price greater than the average price of all products in Products table.

Step by Step Solution

3.46 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

ID Order ID Name Product Name ID Price 001 123 NGUYEN THI BE Mouse P01 200 002 124 surat Keyboard P0... 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

Define self-awareness and cite its benefits.

Answered: 1 week ago

Question

What is a make-or-buy decision?

Answered: 1 week ago

Question

Discuss the differences between triggers and stored procedures.

Answered: 1 week ago