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.