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.

Question

Quizplus · Accepted Answer

The query selects the VendorID and calculates the sum of POTotal for each vendor by grouping them based on their VendorID. Therefore, the result of the query will display the vendor ID and the sum of all purchase order totals for that vendor.

Consider the Following SQL Query