Question: Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

Step by Step Solution

★★★★★

3.17 Rating (178 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Query SELECT CCustomerID CustomerName FROM CustomerT C OrderT O1 OrderLineT OL1 WHERE CCust... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1884).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Q:

Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.

Q:

For each product, display in ascending order, by product ID, the product ID and description, along with the customer ID and name for the customer who has bought the most of that product; also show...

Q:

Which query determines the customers who have ordered themost books from JustLee Books? a. SELECT customer# FROM orders JOIN orderitems USING (order#) HAVING SUM (quantity) = (SELECT MAX (SUM...

Q:

Using Teradata ViewPoint Database: db_pvfc11_big 1. List the names the number of products, and the average product price of each product line whose average price is greater than $200. 2. List the...

Q:

Using Teradata ViewPoint Database: db_pvfc11_big 6. Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4. 7. List the IDs and names of all products that...

Q:

Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

Q:

. Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

Q:

Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4 on the same order.

Q:

What is the output of the following SQL statement? Select customerid, customername from customer _ t where customerid in ( select customerid from order _ t where orderid in ( select orderid from...

Q:

I need some help and explanation will be a text-based .cpp file including your C++ program and a text-based .sql file including your Oracle stored procedures for the Database Application ....

Q:

I. Do you think treating employees in Tasty Meal is unfair? Justify. Keep the unemployment factor, poverty and economical environment in mind. II. Should Tasty Meal be accused for health issues by...

Q:

Open EndRunGuide. pdf, the EndRun Financial Services Guide to Investing. Reexamine EndRuns supporting data for the More Winners Than Losers and The Big Eight Difference and then answer the...

Q:

What is the program if y is passed to foo by value / reference? Explain your answer. x:integer x: = 2 procedure foo ( y:integer ) y: = 8 print x print y x: = 4 foo ( x ) print x Solve and explain how...

Q:

T F Suppose an economist found that total revenues increased for the bus system when fares were raised. The conclusion is that the price elasticity demand for subway services over the range of fare...

Q:

Victoria Ephanor manages a small product distribution company. Because the business is growing fast, Ephanor recognizes that it is time to manage the vast information pool to help guide the...

Q:

David Suker, the inventory manager for a marketing research company, wants to study the use of supplies within the different company departments. Suker has heard that his friend, Ephanor, has...

Q:

ROBCOR, Inc., whose sample data are contained in the database named Ch13_P4.mdb, provides "on demand" aviation charters using a mix of different aircraft and aircraft types. Because ROBCOR has grown...

Q:

The Matterhorn Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) Cash Flow (II) 0 $80,000 $38,000 1 31,000 13,000 2 40,000 27,500 3...

Q:

Which Display Ad format should you use if you're concerned about malware and want a secure ad experience across platforms? AMPHTML ads Search ads Image ads Responsive Display Ads

Q:

The Pioneer Petroleum Corporation has a bond outstanding with an $90 annual interest payment, a market price of $880, and a maturity date in six years. Assume the par value of the bond is $1,000....