Provide 1 .sql file that gives the SQL select statements that need to be used to get the following results. Use the AP database from the book databases. You should have this created already.

1. I want to send a flyer to all Vendors who currently have an invoice that isn't paid. Give me a result set that will allow me to do that.

2. I want to know all of the invoices that have more than 1 item.

3. I want to know all of the invoices with 30, 60 and 90 day terms.

Please write whole CODE out with the TABLE NAMES. IF they are not here inform me so that I may upload them. I need the statements with the Table Names in them.

dbo.ContactUpdates dbo.GLAccounts dbo.InvoiceArchive dbo.InvoiceLineltems ES dboInvoices dbo.Terms dbo.Vendors