(Solved) : 1 Display Employees Including King Manager Order Results Employee Number 2 Create Report H Q32317336 . . . .

1-

display all employees including King, who has no manager.

Order the results by the employee number.

2-

Create a report for the HR department that displays employeelast names, department

numbers, and all the employees who work in the same departmentas a given employee.

Give each column an appropriate label

3-

The HR department wants to determine the names of all theemployees who were hired

after Davies. Create a query to display the name and hire dateof any employee hired after

employee Davies.

4-

The HR department needs to find the names and hire dates of allthe employees who were

hired before their managers, along with their managers’ namesand hire dates

国EmployeeEMP#