CSC 455

Fall 2009

Lab 14 – SQL Query Results

1. Show all employee data for employees who earn more than $50,000. (14 rows in result)

1. Retrieve the name and address of all employees who work for the ‘Research’ department. (6 rows in result)

2. List the names of all employees in department 5 who work more than 10 hours per week on the ProductX project. (2 rows in result)

4. List the names of employees and their supervisor names rename the columns for the supervisor name to be SuperF and SuperL. (33 rows in result)