Consider the Following SQL Query

question 12

Multiple Choice

Consider the following SQL query.Which item best describes the results of the query?SELECT VendorID,Sum(POTotal) FROM [Purchase Orders]GROUP BY VendorID

• A)Displays all purchase order lines for all vendors.
• B)Adds new purchase order information to the purchase orders table.
• C)Displays the vendor ID and all purchase order totals in the purchase orders table.
• D)Displays the vendor ID and the sum of all purchase order totals for that vendor.

---

Definitions:

Hierarchically

In a manner that arranges things or people in order of rank, grade, class, or importance.

Specific Functions

Pertains to distinct tasks or roles designated to individuals, groups, or mechanisms within a system.

Cabinet-Level Department

Departments within the executive branch of the United States government, each led by a Cabinet member who serves as an advisor to the President.

Congress

The legislative body of a country, particularly in the United States, composed of the Senate and the House of Representatives.