This page provides exercises and solutions to help you practice SQL JOIN methods. These exercises are based on the HR database, and may be performed online or by running the sample schema scripts on your local database server. For additional exercises in other subjects, use this link.
 

Inner JOIN Practice

  1. Employees and departments  (Employees & Departments tables)
    1. For each employee, display the first name, last name, department number and department name.
    2. Display the first name, last name, department number and department name, for all employees in departments 50 or 90.
  2. Departments and locations (Departments, Employees & Locations tables)
    1. For each department, display the department name, city, and state province.
    2. For each employee, display the full name, department name, city, and state province.
    3. Display the full name, department name, city, and state province, for all employees whose last name contains the letter a.

 

Would you like to read more?