Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 9, Problem 3HOA
Explanation of Solution
SQL Query:
Refer to the “books”, “orders”, “orderitems” and “customers” tables in the JustLee Books
The SQL statement to perform the stated task with traditional approach is as follows:
SELECT DISTINCT c.lastname, c.customer#
FROM books b, orders o, orderitems i, customers c
WHERE c.customer# = o.customer#
AND o.order# = i.order#
AND i.isbn = b.isbn
AND c.state = 'FL'
AND b.category = 'COMPUTER';
The SQL statement to perform the stated task using the JOIN keyword is as follows:
SELECT DISTINCT c...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
7. List all customers who were referred to the bookstore by another customer. List eachcustomer’s last name and the number of the customer who made the referral.
Task 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.
- Delete the employee who has the longest employment in the company
Knowledge Booster
Similar questions
- Which of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;arrow_forwardYou will be using the Colonial Adventure Tours database. How many reservations include a trip price that is greater than $20 but less than $75?arrow_forwardTask 2: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created.arrow_forward
- Make a list of customers with the list of orders and the amount of dollars that they paid for each of their orders. Make a list of customers with the total amount of dollars that they paid for all their orders combined (for each customer).arrow_forward4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null.arrow_forwardGoogle queries are case sensitive. true or false ?arrow_forward
- Make a list of salespeople who made no sales on a Monday (Hint: your answer to question 1 is a good starting point).arrow_forwardGive quick explanation of each questionarrow_forwardList the customer number, customer last name, and customer first name of each customer that lives in New Jersey (NJ), New York (NY), or Pennsylvania (PA). Us the IN operator in your command. Sort the records by state in descending order and then by customer last name in ascending order.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
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr