(Solved): I Need Help With These In SQL, Please :) 1.Give A List Of Employees (as Emp_FirstName, Emp_LastName)...
I need help with these in SQL, please :)
1.Give a list of employees (as Emp_FirstName, Emp_LastName) and their hire dates (as Emp_HireDate) and their Managers (as Mgr_FirstName, Mgr_LastName). Also include the managers hiredates (as Mgr_HireDate) Name the columns as indicated. Only show names and hire dates.
2.List the customer first name and last name and the number of orders (name the column NumberOfOrders). List all customers even if they have never placed an order. Order the output by number of orders.