Which of the following SQL statements correctly retrieves th…
Which of the following SQL statements correctly retrieves the columns in the order: VendorFirstName, VendorLastName, and VendorName from the Vendors table, and sorts the results first by VendorLastName and then by VendorFirstName in Acending Order? A. SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorFirstName, VendorLastName;B.SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorLastName, VendorFirstName;C.SELECT VendorName, VendorFirstName, VendorLastName FROM Vendors ORDER BY VendorLastName, VendorFirstName;D. SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorFirstName DESC, VendorLastName DESC;