Question: Consider the following SQL query, where VendorID is the unique Identifer of a vendor, and POTotal Is the total amount in a purchase order. Which

Consider the following SQL query, where VendorID is the unique Identifer of a vendor, and POTotal Is the total amount in a purchase order. Which statement best describes the results of the query? SELECT VendorID, Sum(POTotal) FROM [Purchase Orders] GROUP BY VendorID Multiple Choice Displays all purchase order lines for all vendors. Adds new purchase order Information to the "Purchase Orders" table. Displays VendorID and sum of POTotal for all purchase orders Displays VendorID and the sum of POTotal by VendorID. O
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
