Answer:
Select EmailAddress,max(total) from (Select EmailAddress, OrderID, sum(total) as total from OrderItems group by EmailAddress, OrderID) group by EmailAddress
Explanation:
First step is group the rows by email and order id and sum de total of orders
Select EmailAddress, OrderID, sum(total) as total from OrderItems group by EmailAddress, OrderID
Then you use the above query as a subquery grouping by the email and selecting the max value by client
Select EmailAddress,max(total) from (Select EmailAddress, OrderID, sum(total) as total from OrderItems group by EmailAddress, OrderID) group by EmailAddress
Answer:
Write a MARIE program to allow the user to input 8 integers (positive, negative, or zero) and then find the smallest and the largest and print each of these out.
As an example, if the user enters the following decimal numbers as input (one after the other)
23, -6, 78, 0, 36, 3, -250, –5
Explanation:
Answer: Precondition
Explanation: Precondition statement is the statement that has the condition for the particular program that has to be correct or true before the execution otherwise the condition can result as undefined. This statement checks that there is no error in the statement before the function gets called. Similarly post condition is for the checking of the statement after being executed.
A blank presentation is recommended as the starting point when creating a PowerPoint presentation. PowerPoint <span>lets you change the appearance, layout and content of your presentation at any time. Starting with a blank presentation lets you experiment more easily with the many features this program offers.</span>
Answer:
Uhyuuuuufuddirueueurururururru
