Question: Need help! I am stuck on this problem--the text is very dry and the homework questions do not correlate to the chapters.
Problem 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 evaluate the order total from the columns in the OrderItems table.
Problem 2: Write a second SELECT statement that uses the first SELECT statement in it's 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.
Describe each and every problem in depth. You need to execute the search query for the database.