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 help ASAP please and Thank you!