Discuss the below in detail:
Table: Employee
|
EmpID
|
Dept
|
Salary
|
HireDate
|
SupervisorID
|
|
1001
|
Finance
|
10,000
|
11/1/98
|
1020
|
|
1002
|
Finance
|
15,000
|
12/12/96
|
1020
|
|
1020
|
Finance
|
30,000
|
2/9/96
|
1035
|
|
1015
|
Human Resources
|
20,000
|
3/15/01
|
1045
|
|
1008
|
Operations
|
9,000
|
8/22/97
|
1013
|
|
1010
|
Operations
|
12,000
|
7/9/01
|
1013
|
|
1035
|
Operations
|
40,000
|
9/14/95
|
1000
|
|
1007
|
Maintenance
|
5,000
|
10/7/01
|
1017
|
|
1050
|
Human Resources
|
10,000
|
4/5/98
|
1045
|
|
1000
|
Executive
|
60,000
|
11/25/93
|
|
|
1016
|
Human Resources
|
11,000
|
10/13/01
|
1045
|
Q1: Using table Employee, select the names and average salaries for all departments that satisfy the following condition:
- include all departments except HR
- average salaries > 10,000
- sort by department name
Q2: Employee table contains the following fields: ID, firstname, lastname, deptid, managerid, projectid.
Manager table contains the following fields: ID, firstname, lastname, projectID, startdate, enddate.
Department table the following fields: deptID, deptname.
Get all projects started after January 1, 2005 for the 'Operations" department and list the lastname of each employee involved in the project, their manager's lastname, and the start and end dates.