This lesson's interactive features are locked, please to keep using them

Join Practice

Joins take some time to get used to, but the key to understanding them and using them effectively is practice!

Multiple Joins

To incorporate data from more than two tables, you can utilize multiple joins to execute more complex queries!

SELECT *
FROM employees
LEFT JOIN departments
  ON employees.department_id = departments.id
INNER JOIN regions
  ON departments.region_id = regions.id;

Assignment

Our front-end team is finalizing the profile page for CashPal. We need to write a query that returns all the user data they need for an individual user's profile. The query must return the following fields:

The user's id
The user's name
The user's age
The user's username
The user's country name, renamed to country_name
The sum of the amounts of all successful transactions from the user, renamed to balance

Return only a single user record – specifically the one whose id is 6.