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

---

Definitions:

Conservation Biology

The science of protecting and managing biodiversity to prevent species, their habitats, and ecosystems from excessive rates of extinction.

Economic

Relating to the system of production, distribution, and consumption of goods and services in a society, and the study of how scarce resources are allocated.

Biomass

The total mass of all living organisms in a given area or volume; it can also refer to plant or animal matter used as fuel.