Problem: 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.
Use aliases for the tables.
Sort the final result set by lastName, OrderDate, and ProductName.
Provide the query of the given select statement that returns certain columns.