Answered step by step
Verified Expert Solution
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...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