Write a SELECT statement that returns one column from the Ve…
Write a SELECT statement that returns one column from the Vendors table named VendorFullName. Create this column from the VendorFirstName and VendorLastName columns. Format it as follows: vendor last name, comma, vendor first name (for example, “Doe, John”). Filter for contacts whose vendor last name begins with the letter A, B, C, or E (not D). A.SELECT VendorLastName + ‘, ‘ + VendorFirstName AS VendorFullNameFROM VendorsWHERE VendorLastName = ‘A’, ‘B’, ‘C’, ‘E’; B.SELECT VendorLastName + ‘, ‘ + VendorFirstName AS VendorFullNameFROM VendorsWHERE VendorLastName IN ‘%’; C.SELECT VendorLastName + ‘, ‘ + VendorFirstName AS VendorFullNameFROM VendorsWHERE VendorLastName LIKE ‘%’;