1.  Display the name of each employee, the name and department to which the person is assigned, and the location of each department.  Join the EMP and DEPT tables through the WHERE clause.

2. Display the name of each employee, the name of the department to which the person is assigned, and the location of each department.  Join the EMP and DEPT tables using the NATURAL JOIN keywords.

3. Display the name of each employee, the name of the department to which the perso is assigned, and the location of each department.  Join the EMP and DEPT tables using the JOIN…ON keywords.

4. Display the names of each employee, the name of the department to which the person is assigned, and the location of each department.  Join the EMP and DEPT tables using the JOIN…USING keywords.

5. Display the name and job title of each employee and the name of the department they work in.  Use the WHERE clause to create the join.

6. Display the name and job title of each employeeand the name of the department they work in.  Use the JOIN…ON keywords.

7. Display the name and job title of each employee and the name of the department they work in.  Use the JOIN…USING keywords to create the join.

8. Display the name and job title of each employee and the name of the employee’s department.  Include any employee that does not have a department in the results.

9. Display the name of any department that does not have any employees currently assigned to it.

10. Display any department that deos not have a salesman assigned to it.



Source link

Leave a Reply

Your email address will not be published.