SQL  JOINS

If you are unfamiliar with the JOIN concepts,  please take a moment to review the content on this page and access the links provided for a better understanding before you attempt the exercises below -

Exercises

1.  Retrieve names and full address using the INNER JOIN for employees who live either in Washington or Massachusetts

2.  Retrieve the employee first name, last name, dependent first name, last name, and gender for male dependents

3.  Retrieve the employee first name, last name, address, city state, zip, department name, and group name for employee 'David Bradley' HINT:  3 INNER JOINS

4.  Retrieve all employees belonging to the department "Sales and Marketing"  HINT:  2 INNER JOINS

5.  Retrieve the employee first name as 'Name', last name as 'Surname' , middle name as 'MI', department name as 'Dept', and group name as 'Group' for the employee named 'Roberto Tamburello'

6.  Use RIGHT OUTER JOINS to retrieve all Employees, their Department Names and Dependent Names, if any  
HINT:  Use Qualifying Column Names, 3 RIGHT OUTER JOINS

7.  Retrieve the employee first name, last name, dependent first name, last name, and gender for dependents who were born in or before 1998

8.  USE LEFT OUTER JOINS to retrieve all Employees, their Department Names, and Dependent Names, if any
HINT:  Use Qualifying Column Names, 3 LEFT OUTER JOINS

Answer rating: 100% (QA)

Sure here are the SQL queries for each exercise 1 Retrieve names and full address using the INNER JOIN for employees who live either in Washington or ... View the full answer