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:
Windows
Explanation:
The operating system that would be appropiate for Jenny's personal computer is Windows as it is easy to use, the software and programs she is going to need are easily available to install in this operating system and it allows people to interact with it through keyboard and mouse.
Answer:
the answer is c) microsoft windows
Explanation:
Answer:
Variables can represent numeric values, characters, character strings, or memory addresses. Variables play an important role in computer programming because they enable programmers to write flexible programs. Rather than entering data directly into a program, a programmer can use variables to represent the data.
Explanation:
Answer:
It depends upon the programming language that you are working on, and you can set your own error message using the try catch option. As an example, suppose you are working on the C#. Code like below can be added:
using System;
class MainClass {
static void Main(string[] args) {
int a = 5;
int b= 0;
int c= 100/2;
console.WriteLine(c);
try {
int d = a / b;
} catch (DivideByZeroException err) {
Console.WriteLine(err);
}
}
}
System.DivideByZeroException: Attempted to divide by zero.
This will give the above error message. And this is an error message by the system. We can also have a user-defined error message.
Explanation:
Please check the answer.