Which query will return the number of rows where the State field is 'AZ' from the table Customers?
A) SELECT FROM Customers WHERE State='AZ' COUNT(*);
B) SELECT COUNT(*) FROM Customers WHERE State='AZ';
C) SELECT FROM Customers COUNT(*) WHERE State='AZ';
D) SELECT COUNT(*) WHERE State='AZ' FROM Customers;

Question

Quizplus · Accepted Answer

This query will select the count of all rows in the Customers table where the State field is 'AZ'. The syntax is correct, with the SELECT statement preceding the COUNT function and the WHERE clause specifying the condition.

Which Query Will Return the Number of Rows Where the State