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';

Question

Quizplus · Accepted Answer

The correct query is:
SELECT COUNT(*), SUM(Payment) FROM Customers WHERE State='AZ';
This query uses the COUNT() function to get the number of rows where the State field is 'AZ' and the SUM() function to provide a total of the Payment field. It also filters the results using the WHERE clause to only include rows where the State field is 'AZ'. This is the most efficient and accurate way to get the desired results.

Which Query Will Return the Number of Rows Where the State