Write a SELECT statement that returns four columns: VendorName, InvoiceNumber, InvoiceDate, and InvoiceTotal.
Return one row per vendor, representing the vendor's invoice with the earliest date. Sort by vendor name. using a derived table. This is what I have so far before I translate it into a derived table.
select VendorName, min(InvoiceDate), min(InvoiceNumber), InvoiceTotal
from Invoices join Vendors
on Invoices.VendorID = Vendors.VendorID
group by VendorName, InvoiceTotal