Practice 4

Practice 4 - p4q7.sql . 8. Create a query that will display...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENT FOR AST AND ANT JUNE 2004(27th july 2004) Submission date: 28 th july 2004 Practice 4 1. Write a query to display the name, department number, and department name for all employees. 2. Create a unique listing of all jobs that are in department 30. 3. Write a query to display the employee name, department name, and location of all employees who earn a commission. 4. Display the employee name and department name for all employees who have an A in their name. Save your SQL statement in a file called p4q4.sql . 5. Write a query to display the name, job, department number, and department name for all employees who work in DALLAS. 6. Display the employee name and employee number along with their manager’s name and manager number. Label the columns Employee, Emp#, Manager, and Mgr#, respectively. Save your SQL statement to a file called p4q6.sql . 7. Modify p4q6.sql to display all employees including King, who has no manager. Resave as p4q7.sql . Run
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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 managers 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

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online