Unformatted text preview: p4q7.sql . 8. Create a query that will display the employee name, department number, and all the employees that work in the same department as a given employee. Give each column an appropriate label. 9. Show the structure of the SALGRADE table. Create a query that will display the name, job, department name, salary, and grade for all employees. 10. Create a query to display the name and hire date of any employee hired after employee Blake. 11. Display all employees’ names and hire dates along with their manager’s name and hire date for all employees who were hired before their managers. Label the columns Employee, Emp Hiredate, Manager, and Mgr Hiredate, respectively. 12. Create a query that displays the employees name and the amount of the salaries of the employees are indicated through asterisks. Each asterisk signifies a hundred dollars. Sort the data in descending order of salary. Label the column...
View Full Document
- Summer '10