3 Write a query pulling the latest InvoiceDueDate and Vendor

3. Write a query pulling the latest InvoiceDueDate and VendorID from invoices.

Solution

There was nothing mentioned of what kind of query do you ask for so I am providing a SQL query.
\"SELECT InvoiceDueDate, VendorID FROM invoices ORDER BY InvoiceDueDate DESC\"

Here 2 columns of data \"InvoiceDueDate, VendorID\" will be fetched form table \"invoices\" and will me ordered in Descendig order. You can change it to Ascending by replacing \"DESC\" with \"ASC\".