Multiple Choice
Which query will return the number of rows where the State field is 'AZ' from the table Customers and provide a total of the Payment field?
A) SELECT COUNT(*) WHERE State='AZ' SUM(Payment) FROM Customers;
B) SELECT FROM Customers COUNT(Payment) SUM(*) WHERE State='AZ';
C) SELECT FROM Customers SUM(Payment) WHERE State='AZ' COUNT(*) ;
D) SELECT COUNT(*) , SUM(Payment) FROM Customers WHERE State='AZ';
Correct Answer:

Verified
Correct Answer:
Verified
Q57: The _ clause is to groups as
Q58: Discuss the restriction about the structure of
Q59: When rows are grouped, one line of
Q60: Use the _ clause to sort data.
Q61: SQL has built-in functions, which are also
Q63: By using the word _ in a
Q64: Based on the code shown, which query
Q65: Based on the code shown, which query
Q66: Based on the code shown, which query
Q67: Computed fields are existing fields in the