Reference no: EM13930583
**First Problem**
Table: Employee (for problems #1 and #2)
|
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
|
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
**Second Problem**
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.