Which Query Will Return the Number of Rows Where the State

question 29

Multiple Choice

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;

---

Definitions:

Kansas

A U.S. state located in the Midwestern part of the country, known for its agricultural outputs, like wheat and corn, and as the setting of the famous novel "The Wizard of Oz."

Primary Succession

Primary succession is an ecological process of community development that occurs in an environment previously uninhabited by living organisms, starting from bare rock or barren soil.

Lava

The molten rock expelled by a volcano during an eruption, which solidifies as it cools to form igneous rock.

Sand Dunes

Natural formations of sand accumulated by wind or water flow, often found in deserts and coastal regions.