Write a select statement that returns three columns

Assignment Help PL-SQL Programming

Reference no: EM13703726

Query 1: Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table.

Query 2: Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer's email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.

I'm not sure how to answer the question. Can anyone help me?

Reference no: EM13703726

Questions Cloud

Difference between x and &x : Suppose x is defined as int x = 5; Explain in your own words what the difference between x and &x.

Write a function named putinorder : Write a function named "PutInOrder" that has 2 double reference parameters (say a and b). The function rearranges the values pointed to by a and b such that a points to the smallest value and b to the largest value.

Correlated sub-query to return one row per customer : Use a correlated sub-query to return one row per customer, representing the customer's oldest order (the one with the earliest date).

Draw the arrow pushing mechanism of reaction : Problem- The combination of sodium chlorite and acetic acid forms hypochlorous acid (HOCl). Draw the arrow pushing mechanism of your reaction, using HOCl as reagent.

Write a select statement that returns three columns : Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns.

Explain the average mass of an atom of sodium : Problem- Suppose that the atomic mass unit (amu) had been defined as one-tenth of the average mass of an atom of sodium instead of one-twelfth of the mass of an atom of carbon-12.

Write select statement that returns categoryname : Write a SELECT statement that returns the CategoryName column from the Categories table.

Write a select statement that answers the problem : Write a SELECT statement that answers this problem - Which products have a list price that's greater than the average list price for all products?

What is the concentration of the hcl : Problem- A student pipets 10 mL of HCl into a beaker and dilutes it to 25mL with water He adds .20M NaOH to a burette. The initial reading of the burette is 26.45 mL and the final reading is 10.05 mL several drops of phenolpthalein are added as an..

User Account

All Pages