SQL

.Write a SELECT statement that returns one column from theVendor table named Full Name. Create this column from theVendorContactFName and VendorContactLName columns. Format it asfollows: last name, comma, first name (for example, “Doe, John”).Sort the result set by last name, then by first name.