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:

1. Jim Adams posts the column totals and individual transactions in "Other" columns to the appropriate general ledger account and updates each general ledger account balance. He places a posting...

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:

Suppose a file system is based on the index allocation strategy for managing blocks. Assume each file has a directory entry giving the filename, first index block, and the length of the file. The...

Q:

Using the data in the Excel file Freshman College Data, identify the best regression model for predicting the first year retention rate. For the model you select, conduct further analysis to check...

Q:

Luciana is conducting a preliminary investigation into her company. She has discovered a new law is going into effect that makes it a mandatory present external constraint. Which of the following is...

Q:

Muhsin Company has gathered the information shown on the next page about its product. Direct materials: Each unit of product contains 4.5 pounds of materials. The average waste and spoilage per unit...

Q:

Payback and NPV methods, no income taxes. (CMA, adapted) Andrews Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is...

Q:

Manufacturing overhead data for the production of Product H by Norland Company are as follows. Overhead incurred for 52,000 actual direct labor hours worked ...$213,000 Overhead rate (variable $3;...

Q:

Rapid Repair Services, Inc. is trying to establish the standard labor cost of a typical oil change. The following data have been collected from time and motion studies conducted over the past month....

Q:

The standard cost of Product B manufactured by Mateo Company includes three units of direct materials at $5.00 per unit. During June, 28,000 units of direct materials are purchased at a cost of $4.70...

Q:

Give several examples of why all managers should have human resource management knowledge and skills.

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....