Sort the output by OrderDate then by CustomerID. Since several of the fields use the same name use column aliases where needed to differentiate between the columns with the same names

7. List all employees and their Job. Show the employee's First and Last Name, Title and their job description. Concatenate the First and Last Name columns of the employees.

8. Write a select query that lists the OrderId, EmployeeID and CustomerId for the orders shipped prior to January 1st 2014. Show each OrderId only once.