Turn in a .txt file with the SQL Select statements that you used to answer the q

Question

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! Not hand written please!

Explanation / Answer

1 Answer)

SELECT vendor_names, phone_number

FROM AP.vendorTable

ORDER BY state;

2 Answer)

SELECT invoiceNumber, invoiceDate, creditTotal

FROM AP.invoiceTable

WHERE EXISTS ( SELECT creditTotal FROM AP.invoiceTable where invoiceNumber = invoiceTable.invoiceNumber);

NOTE: Please create a text file based on the above query because this page doesn't allow to attach any file.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.