CSC 455 Fall 2009

Lab 15 – SQL Query Results

1. Find the names of all employees who do not have a supervisor. (7 rows)

1. Show the average salary by department. (6 rows)

2. Show the average salary by department name instead.

3. List Essn of employees who work on two or more projects. (7 rows)

4. List the first name, last name, and number of projects of employees who work on two or more projects.

5. Use a nested query with IN to show the name of the employee with the highest salary.