Computers and Technology
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;