Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock

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

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 Databases Questions!

List the balance characteristics of the customers who have made purchases during the current invoice cyclethat is, for the customers who appear in the INVOICE table. The results of this query are...

Write an SQL query to list each customer who bought at least one product that belongs to product line Basic in March 2015. List each customer only once.

Write SQL queries to answer the following questions: a. List the numbers of all sections of course ISM 3113 that are offered during the semester "1-2015." b. List the course IDs and names of all...

Many companies sell products allowing their customers the right to return merchandise if they are not satisfied. Because the return of merchandise can retroactively negate the benefits of having made...

Virginia Semiconductor is a leading manufacturer of prime silicon substrates. The company, situated in Fredericksburg, Virginia, was founded in 1978 by Dr. Thomas G. Digges and his brother, Robert....

A hydraulically operated multidisk plate clutch has an effective disk outer diameter of 6.5 in and an inner diameter of 4 in. The coefficient of friction is 0.24, and the limiting pressure is 120...

The figure shown is a geared countershaft with an overhanging pinion at C. Select an angular-contact ball bearing from Table 112 for mounting at O and a straight roller bearing for mounting at B. The...

Brackets, such as the one shown, are used in mooring small watercraft. Failure of such brackets is usually caused by bearing pressure of the mooring clip against the side of the hole. Our purpose...

Write SQL statements to perform the following operations on the wine cellar database: a. Get bin number, name of wine, and number of bottles for all Geyser Peak wines. b. Get bin number and name of...

Show the effects of the following SQL update operations on the wine cellar database of fig: a. INSERT INTO CELLAR(BIN#, WINE, PRODUCER, YEAR, BOTTLES, READY) VALUES(80, Syrah, Meridian, 1998, 12,...

PT XYZ provides installation, mechanical, and electrical services for 4 types of consumers. Data related to the four types of consumers of PT XYZ are as follows: Type A Type B Type C Type D Gross...

5. An outside manufacturer has offered to produce 86,000 Daks and ship them directly to Andretti's customers. If Andretti Company accepts this offer, the facilities that it uses to produce Daks would...

Howard is in the 33% tax bracket, so his after-tax profit is 67% of his before-tax profit. He invests $10,000 in a certain stock, whose annual return is normally distributed with mean 5% and standard...

Hardyke Group operates a local after-school recreation and activities program. The Education Department is a state governmental agency. Hardyke has an agreement with the Department to provide...

C TBM aw 2 Exercise 16-38 (Static) Flexible Budget (LO 16-2) 52 nts Golden Food Products produces special-formula pet food. The company carries no inventories. The master budget calls for the company...

Abercrombie & Fitch Co.-Transactions and Financial Statements Abercrombie & Fitch Co., a Delaware corporation, is principally engaged in the purchase, distribution and sale of men's, women's and...

#include using namespace std; int main ( ) { char letterToQuit; int numPresses; cin > > letterToQuit; cin > > numPresses; / * Your solution goes here * / return 0 ; }

What is a make-or-buy decision?

Discuss the differences between triggers and stored procedures.

Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you...

Give an example of the use of effective (or affectivity) dates as attributes of an entity.

1.9. A BBC story (September 9, 2004) about a poll in 35 countries concerning whether people favored George W. Bush or John Kerry in the 2004 U.S. Presidential election stated that Kerry was clearly...

1.12. Using a spreadsheet program (such as Microsoft Office Excel) orstatistical software, yourinstructor will help the class create a data file consisting of the values for class members of...

1.6. Go to the GSS Web site, sda.berkeley.edu/GSS/. By entering TVHOURS as the Row variable, find a summary ofresponses to the question, "On a typical day, about how many hours do you personally...