SQL:

Using the AP database, write a single query that creates a new table called LatestInvoices that captures vendor and invoice data for the following attributes in the Invoices and Vendors tables.

The first three columns should provide the vendor names, invoice numbers, and invoice totals. You should return only vendor information for vendors that have invoices.

The fourth and fifth column should provide the invoice due date (column called Invoice Due Date) and the payment date (column called Payment Date). All dates should be provided in the following format: mon dd, yyyy.

The data placed in this table should include only data where the invoice date is equal to or newer than the last invoice in 2015.