Which Query Will Return the Number of Rows from the Customers

question 26

Multiple Choice

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;

---

Definitions:

American College of Physicians

A professional organization for internal medicine physicians, dedicated to improving patient care, education, and public health.

American Medical Association

A professional group representing the interests of physicians and healthcare professionals in the United States, advocating for public health and the advancement of the medical profession.

American Hospital Association

A national organization that provides education, advocates on behalf of its members, and creates guidelines to support hospital and healthcare administration.

American Society of Clinical Pathologists

A professional association aimed at providing excellence in pathology and laboratory medicine through certification, education, and advocacy.