SQL Please fill in the 6 blanks below with the correct SQL commands. Thank you!

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_contacts WHERE __________ = vendor_contacts.contact_id AND vendor_state = IA;

Fill in the blanks in the SQL statement below that will list all vendor names for vendors with a name that begins with a letter from A to L.

SELECT name FROM vendors WHERE __________ BETWEEN A AND ____________ ;

Fill in the blanks in the SQL statement below that will list the invoice_id, invoice_total and payment_total that were due with 25 days of the invoice date.

SELECT invoice_id, invoice_total , payment_total FROM invoices WHERE invoice_due_date

Accounts Payable Database Listing Description of tables in the AP database Table: general_ledger_accounts general_ledger_accounts(account_number, description) Table: terms terms(terms_id, description, due_days) Table: vendor contacts vendor_contacts(contact_id, last_name, first_name) Table: vendor vendor(vendor_id, name, address1, address2, city, state, zip, phone, contact id, default_terms_id, default_account_number) Table: invoices invoices(vendor_id, number, invoice_date, invoice_total, payment_total, credit_total, terms_id, invoice_due_date, payment_date) Table: invoice_line_items invoice_line_items(invoice_id, sequence, a ccount number, amount, descriptiou