Turn in a .txt file with the SQL Select statements that you used to answer the questions in scenario 1 and 2.

Scenario 1: My boss wants a list of all of the vendor names and phone number ordered by state so that she can contact them. Using the AP database, write a select statement that will retrieve these results. We only want the vendor names and phone number in the result set.

Scenario 2: My boss wants a list of all of the invoices that have a credit total and wants the list sorted by the invoice number. We only want to see the invoicenumber, invoice date, and credit total. We only want to see records for those that have a credit total in the result set

Need with table names in it please ASAP!

Here is the list

Let me know if anything is missing please

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