5. Determine the profit of each book sold to Jake Lucas, using the actual price the customer paid (not the book’s regular retail price). Sort the results by order date. If more than one book was ordered, sort the results by profit amount in descending order. Perform the search using the customer name, not the customer number.

5. Determine the profit of each book sold to Jake Lucas, using the actual price the customer paid (not the book’s regular retail price). Sort the results by order date. If more than one book was ordered, sort the results by profit amount in descending order. Perform the search using the customer name, not the customer number.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 5HOA

See similar textbooks

Similar questions

How do you indicate that a column alias should be used?
Find the listing of customers who did not make purchases during the invoicing period. Sort the results by customer code. Your output must match the output shown in Figure P7.23.
Determine which orders had a higher total amount due than order 1008.
Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your student table select all students where the last name starts with an “S” and is at least three characters in length.
Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Task 11: Find the ID, first name, and last name of each customer whose first name begins with the letter S.
question 15 please use the picture below to answer the following question Display customer number, customer name, and location for customers whose Customer_name starts with letter C. Sort the result based on customer number.
For each order id, calculate the total of the Order. The total of an order is the sum of the prices of all the products (price*quantity) in that order. Sort the results in ascending order.
List all customers who were referred to the bookstore by another customer. List each customer's last name and the number of the customer who made the referral.
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.
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 t