Answer:
The code is given, paying attention to every column details
Explanation:
columns:
InvoiceNumber
InvoiceDate
InvoiceTotal
InvoiceLineItemDescription
InvoiceLineItemAmount
SELECT InvoiceNumber, InvoiceDate, InvoiceTotal, InvoiceLineItemDescription AS ItemDescription, InvoiceLineItemAmount AS ItemAmount
FROM Invoices AS Invoice JOIN InvoiceLineItems AS LineItem
ON Invoice.InvoiceID = LineItem.InvoiceID
WHERE Invoice.InvoiceID IN (
SELECT InvoiceID
FROM InvoiceLineItems
GROUP BY InvoiceID
HAVING COUNT(*) > 1)
ORDER BY InvoiceDate
FOR XML RAW, ELEMENTS;