Question: Oracle SQL Question: Write a query that returns three columns for each order: email_address of the customer, order_id, and the order total. To do this,

Oracle SQL Question:

Write a query that returns three columns for each order: email_address of the customer, order_id, and the order total. To do this, group the result set by the email_address and order_id columns. In addition, you must calculate the order total from the columns in the Order_Items table. (You will not need subqueries to complete this exercise.)

Sort the results in descending sequence by order total.

Write a query that uses the query you created in the previous exercise in a subquery factoring clause. The main query should return the order_id and customer's email_address for orders whose total is greater than the average of the order totals.

Order the results by order_id in ascending order

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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

Students Have Also Explored These Related Databases Questions!

Oracle SQL Question: Write a query that returns three columns for each order: email_address of the customer, order_id, and the order total. To do this, group the result set by the email_address and...

4. Write a SELECT statement that returns three columns: email address, order id, and the order total for each customer. To do this, you can group the result set by the email address and order_id...

need to write SQL statements using the myguitarshop.sql database Write a SELECT statement that returns the same result set as this SELECT statement, but don't use a join. Instead, use a subquery in a...

I need these 6 queries completed . Thank you. /* Query 1 . Write a SELECT statement that returns the same result set as the SELECT statement below, but dont use a join. Instead, use a subquery in a...

MySQL or SQL needed. 1. Write a SELECT statement that returns the same result set as this SELECT statement, but dont use a join. Instead, use a subquery in a WHERE clause that uses the IN keyword....

Chapter 6: How to Code Summary Queries Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address column from the Customers table The sum of...

Chapter 6 How to code subqueries Exercise Save a TEXT COPY of the query 1. Write a SELECT statement that returns the same result set as this SELECT statement, but dont use a join. Instead, use a...

DBS 3 1 1 Advanced Data Services Last update: Summer 2 0 2 4 Advanced Databae Services Assignment 1 SubmissionYour submission will be a single text - based SQL file ( . sql ) with appropriate header...

/* Query 4. This query requires you to write two SELECT statements described below. Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer....

Find the sample size needed to estimate the percentage of Democrats who have tattoos. Use a 0.05 margin of error, a confidence level of 99%, and results from a prior Harris poll suggesting that 15%...

Is there any crime that you think should never allow a felon to vote again? Should Felons be given voting rights back when they get out based on what crime they committed or just given their right to...

Consider the following three alternatives. There is also a " do nothing" alternative. At the end of the 5 - year useful life of \ ( A \ ) , a replacement is made. If a 1 0 - year analysis period and...

please help with this (and explaination) thank you very much. The following transactions occurred during March 2021 for the Wainwright Corporation. The company owns and operates a wholesale...

=+pandemic (that began in 2020)? What personal, organizational, and country issues would confront the Baileys and Kline & Associates? If you were Fred Bailey,

=+3 What are the root causes of the problems that Fred Bailey experienced?

=+1 Who has responsibility for this situation? What is the nature of various stakeholders responsibilities? Headquarters HR? Japan HR? Fred Bailey? Jennifer Bailey? Dave Steiner, the company managing...