Prepare a SQL statement to use joining the tables.
Question: Write a SELECT statement that joins the Customers, Orders, OrderItems, and Products tables.
This statement should return these columns: LastName, FirstName, OrderDate, ProductName, ItemPrice, DiscountAmount, and Quantity.
Prepare this query and sort the final query result set by LastName, OrderDate, and ProductName. Use aliases for the tables.