Answer:
See Explaination
Explanation:
SELECT TOP 10 VendorName AS Name, MAX(InvoiceDate) AS LastInvoice, SUM(InvoiceTotal) AS SumOfInvoices
FROM dbo.Vendors V JOIN dbo.Invoices I
ON V.VendorID = I.VendorID
WHERE PaymentDate IS NOT NULL
GROUP BY VendorName
ORDER BY SumOFInvoices desc;
Answer:
It is called the ENQUIRE database
Explanation: got it right boooiiiii
