Solved

Which Query Will Return the Number of Rows Where the State

Question 62

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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions