Share
Explore BrainMass

SQL statements

I am seeking help with solving several SQL statements. I am specifically looking for the code that goes with these problems.

**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.

Attachments

Solution Preview

Try the following. I could not test the code because I do not have SQL in my pc. If it does not work, you can repost and ask for refund. I ...

Solution Summary

SQL statements are examined.

$2.19