using SQL theory

d. List all Customer IDs, the Order ID of the orders they have submitted if any, and the employee ID that handled the order. All employees (including those who have never handled an order) and all customer IDs (including those who have never submitted an order) must also be listed. The list must be ordered in ascending order of the employeeld, and then in ascending order of the orderid (if the employee is listed more than once). A sample of the expected result from a different data set is provided below: Customer ID ABCD has never submitted an order and employee ID 55 and employee ID 4 have never handled an order. CustomerID OrderID EmployeeID ABCD DCBA 11231 11 DCBA 10101 2 EBAC 11123 2 4 55