SQLite JOINS - Exercises, Practice, Solution

Last update on June 13 2023 07:59:59 (UTC/GMT +8 hours)

SQLite Joins [11 exercises with solution]

[An editor is available at the bottom of the page to write and execute the scripts. Go to the editor]

1. Write a query to find the addresses (location_id, street_address, city, state_province, country_name) of all the departments.
Hint : Use NATURAL JOIN.

Sample table : locations

Sample table :countries

Click me to see the solution

2. Write a query to find the names (first_name, last name), department ID and the name of all the employees.

Sample table : employees

Sample table : departments

Click me to see the solution

3. Write a query to find the employee id, name (last_name) along with their manager_id, manager name (last_name).

Sample table : employees

Click me to see the solution

4. Write a query to find the names (first_name, last_name) and hire date of the employees who were hired after 'Jones'.

Sample table : employees

Click me to see the solution

5. Write a query to get the department name and number of employees in the department.

Sample table : employees

Sample table : departments

Click me to see the solution

6. Write a query to find the employee ID, job title number of days between ending date and starting date for all jobs in department 90 from job history.

Sample table : employees

Click me to see the solution

7. Write a query to display the department ID, department name, and manager first name.

Sample table : employees

Sample table : departments

Click me to see the solution

8. Write a query to display the department name, manager name, and city.

Sample table : employees

Sample table : departments

Sample table : locations

Click me to see the solution

9. Write a query to display the job title and average salary of employees.