Question

Write a SELECT statement that returns four columns: VendorName, InvoiceNumber, InvoiceDate, and InvoiceTotal. Return one row per invoice that shows the vendor and invoice results that have an invoice date that is the same as any of the United Parcel Service invoices. Organize the results by invoice date from earliest to latest invoice.

Answer 1

SELECT VendorName, InvoiceNumber, InvoiceDate, InvoiceTotal

FROM Vendor JOIN Invoice ON Vendors.VendorID = Invoices.VendorID

WHERE InvoiceDate = United_parcel_service

ORDER BY InvoiceDate DESC

Step-by-step explanation:

A database is a storage unit where data is stored for future reference. SQL or structure query language is a programming language used to query databases for specific information.

The SELECT clause is used to read data from the database table. The JOIN and ON clauses are used to query multiple tables and databases. The WHERE clause is used to select and return rows based on a given condition, where the ORDER BY clause is used to sort and organize the returned result.