Fill in the blanks in the SQL statement below that will list the vendor number, vendor name, vendor contact name for all vendors located in Iowa. Format all vendor contact names as last name, first name (example: Bucket, Charles) and name the column contact. SELECT vendor_id, name, (last_name, ‘, ‘, first_name)AS FROM vendors, vendor_contactsWHERE = vendor_contacts. contact_id AND vendor_state = ‘IA’;

Following are the response to the given query:

Explanation:

Following are the update out the blanks inside the following SQL query that lists all vendor number, seller name, vendor contacts information again for Iowa vendor. Format all seller number represents as their surname, their first name (example: Bucket, Charles). This SQL query joins two vendors of tables, vendor contacts & returns results.

Please find the query in the attached file.