Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 6.74PAE
Program Plan Intro
SQL query to show customer ID and name of all customers who ordered products with ID 3 and 4 in the same order.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For every completed or 'open service request for janitorial work', list the condo id, description, and status.
Orders Table:
OrderID, CustomerID, Order Date, TotalAmount
Customers Table:
CustomerID,CustomerName.
Retrieve the customer name and order date
for each order placed by customers who have
made more than two orders.
Find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10.000
Chapter 6 Solutions
Modern Database Management
Ch. 6 - Define each of the following terms: dynamic view...Ch. 6 - Match the following terms to the appropriate...Ch. 6 - Prob. 6.3RQCh. 6 - Prob. 6.4RQCh. 6 - Prob. 6.5RQCh. 6 - Explain the relationship between EXISTS and...Ch. 6 - Prob. 6.7RQCh. 6 - Under what conditions can a UNION clause be used?Ch. 6 - Prob. 6.9RQCh. 6 - Explain why it is necessary to limit the kinds of...
Ch. 6 - Describe a set of circumstances for which using a...Ch. 6 - Prob. 6.12RQCh. 6 - Prob. 6.13RQCh. 6 - Prob. 6.14RQCh. 6 - Prob. 6.15RQCh. 6 - Prob. 6.16RQCh. 6 - Prob. 6.17RQCh. 6 - Prob. 6.18RQCh. 6 - Prob. 6.19RQCh. 6 - List for advantages of SQL-invoked routines.Ch. 6 - Prob. 6.21RQCh. 6 - Prob. 6.22RQCh. 6 - Prob. 6.23RQCh. 6 - This chapter discusses the data dictionary views...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Write SQL retrieval commands for each of the...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Write SQL queries to answer the following...Ch. 6 - Write SQL queries to answer the following...Ch. 6 - Write an SQL query to answer the following...Ch. 6 - Prob. 6.31PAECh. 6 - Prob. 6.32PAECh. 6 - Prob. 6.33PAECh. 6 - What do you need to do if a tutor signs up and...Ch. 6 - Prob. 6.35PAECh. 6 - Write the SQL query to find any tutors who have...Ch. 6 - Prob. 6.37PAECh. 6 - Write an SQL query to determine the total number...Ch. 6 - Prob. 6.39PAECh. 6 - Prob. 6.40PAECh. 6 - Prob. 6.41PAECh. 6 - Prob. 6.42PAECh. 6 - Prob. 6.43PAECh. 6 - Which tutor needs to be reminded to tum in...Ch. 6 - Prob. 6.45PAECh. 6 - Write an SQL query to list all product line names...Ch. 6 - Modify to include only those product lines the...Ch. 6 - Prob. 6.48PAECh. 6 - Prob. 6.49PAECh. 6 - Write an SQL query to display the order number,...Ch. 6 - Prob. 6.51PAECh. 6 - Prob. 6.52PAECh. 6 - Prob. 6.53PAECh. 6 - Prob. 6.54PAECh. 6 - Prob. 6.55PAECh. 6 - Prob. 6.56PAECh. 6 - Prob. 6.57PAECh. 6 - Prob. 6.58PAECh. 6 - Write an SQL query to list each customer who...Ch. 6 - Prob. 6.60PAECh. 6 - Modify Problem and Exercise 6-60 so that the list...Ch. 6 - Prob. 6.62PAECh. 6 - Prob. 6.63PAECh. 6 - Prob. 6.64PAECh. 6 - Prob. 6.65PAECh. 6 - Prob. 6.66PAECh. 6 - Prob. 6.67PAECh. 6 - Prob. 6.68PAECh. 6 - Prob. 6.69PAECh. 6 - Prob. 6.70PAECh. 6 - Prob. 6.71PAECh. 6 - Rewrite your answer to Problem and Exercise 6-71...Ch. 6 - Display the customer ID, name, and order ID for...Ch. 6 - Prob. 6.74PAECh. 6 - Prob. 6.75PAECh. 6 - Prob. 6.76PAECh. 6 - Prob. 6.77PAECh. 6 - Prob. 6.78PAECh. 6 - Prob. 6.79PAECh. 6 - Write an SQL query to list the order number,...Ch. 6 - Prob. 6.81PAECh. 6 - Prob. 6.82PAECh. 6 - Prob. 6.83PAECh. 6 - Prob. 6.84PAECh. 6 - Prob. 6.85PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Add the following record to the VACATION_UNIT table: condo ID: 20; location number: 2; unit number: A04; square feet: 1680; bedrooms: 3; bathrooms: 3; condo fee: 775; and owner number: BL720. Display the contents of the VACATION_UNIT table.arrow_forwardHow do you indicate that a column alias should be used?arrow_forwardUsing the WHERE clause, filter the invoice table to find the invoices that were dated after March 1st, 2009. Identify the first customer ID of the invoice. 17 2 19 16arrow_forward
- please create a subquery using sqlarrow_forwardNote:- Do correct answer get upvote Else downvotedarrow_forwardThe code: "SELECT SupplierlD FROM Products Order By SupplierName DESC;" extracts data from Products table and sorts the SupplierName by order. alphabetical reverse alphabetical chronological randomarrow_forward
- WEEK 9 ASSIGNMENT#6 Part II: Complete the following exercise: Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the course id where the average GPA is 2. Using a subquery, select the course id where the average GPA is greater than 2. Using a subquery, select student first name where the student is not in the student course tarrow_forwardDisplay user name and their city who have booked their tickets not by using HDFC bank for any of the bookings. Sort the result based on user name. SQL Code Required BUSES number(11) BUS_NAME varchar2(20) t varchar2(20) t TOTAL_SEATS number(11) # AVAIL_SEATS number(11) # PBUS NO SCHEDULE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) O number(11) * SCHEDULE_ID TRAVEL DATE TYPE SOURCE BUS NO O BUS_NO DURATION PAYMENTS DISCOUNTS varchar2(3) PAYMENT_ID varchar2(3) t varchar2(3) number(11) DISCOUNT ID varchar2(3), DISCOUNT ID DISCOUNT AMOUNT number(11) # TICKET ID BD ID O TICKET_ID O O BD_ID TICKETS DISCOUNT_ID varchar2(3) O SCHEDULE_ID varchar2(3) number(11) # number(11) O number(11) # TICKET ID SCHEDULE ID FARE USER ID File Edit Format View OUSER ID NO SEATS USERS number(11) varchar2(20) t ADDRESS varchar2(100) t number(11) # EMAILID varchar2(30) t USER ID P primary key - not null NAME e foreign key PHNO # data type - number d data type - date CANCELLATION It|…arrow_forwardInsert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and owner number from the PROPERTY table whose square footage is greater than 1,500 square feet.arrow_forward
- Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than5000.Q2- List all employee except those with employee_id 101, 102, 103, 104 and 105Q3- Display the city attribute from locations table. Show the ones that contain “South” in the city.Sort the list in descending order.Q4- Display the first name, last name, salary, manager id and job id of all employees whose last fourcharacters of job id ends with “LERK”.Q5- Display the first name, last name and salary of all employees. Round the salary to the nearestunit of 1000 (ex. Salary=4500 New Salary=5000). Label the column as "New Salary".arrow_forwardList the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator. table name is:ORDER_LINEORLN_ORDER_NUMBER ORLN_PART_NUMBER ORLN_NUMBER_ORDERED ORLN_QUOTED_PRICE tablename is ORDER_TABLE ORDR_ORDER_NUMBER ORDR_ORDER_DATE ORDR_CUSTOMER_NUMBER tablename is CUSTOMER CUST_NUMBERCUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES_REP_NUM tablename is PART PART_NUMBER PART_DESCRIPTION UNITS_ON_HAND ITEM_CLASS WAREHOUSE UNIT_PRICE tablename is SALES_REP SLSR_PKSLSR_LAST SLSR_FIRST SLSR_STREET SLSR_CITY SLSR_STATE SLSR_ZIP_CODE SLSR_TOTAL_COMMISSION SLSR_COMMISSION_RATE SELECT ORDR_ORDER_NUMBER, ORDR_ORDER_DATEFROM ORDER_TABLEWHERE ORDR_ORDER_NUMBER IN (SELECT ORLN_ORDER_NUMBERFROM ORDER_LINEWHERE ORLN_PART_NUMBER IN (SELECT PART_NUMBERFROM PARTWHERE…arrow_forwardTask 19: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for each sales rep. Order and group the results by sales rep ID.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage