III. SubQueries in SQL: In the database ProductOrders created in the previous exercise, write the following...

Transcribed Image Text:

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' (Nguyễn Thị Bé). 10. List all products having price greater than the average price of all products in Products table. 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' (Nguyễn Thị Bé). 10. List all products having price greater than the average price of all products in Products table.

Answer rating: 100% (QA)

ID Order ID Name Product Name ID Price 001 123 NGUYEN THI BE Mouse P01 200 002 124 surat Keyboard P0... View the full answer