Write a SELECT that gets the vendor_name and the contact name for each vendor. Display the contact name as one name, i.e. the first and last name in one column, FirstName LastName and label it FULL NAME If there is no contact name for the vendor then output N/A Sort the results by vendor name Hint: You will need to use an OUTER JOIN to join the vendors and vendor_contacts tables and test for NULL in the name field. You only need to test the first or the last name, if one of them is NULL you know the other is also.