Which query will return the number of rows from the Customers table where the State field is 'AZ'?
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

The correct syntax for counting rows in a SQL query that matches a specific condition is "SELECT COUNT(*) FROM [Table] WHERE [Condition];". Therefore, option B correctly uses this syntax to count the number of rows in the Customers table where the State is 'AZ'.

Which Query Will Return the Number of Rows from the Customers