Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Table Join Practice | Joining Tables
Intermediate SQL
course content

Course Content

Intermediate SQL

Intermediate SQL

1. Grouping
GROUP BYOrder of StatementsTotal Ride Time for Each Subway Line ChallengeAverage Student's Grade ChallengeSearching for the Top Math Students ChallengeHAVINGSeveral Aggregate Functions in the QueryMore Complex Filtering
2. Nested Subqueries
Nested QueriesNon-tech Department Employees ChallengeUsing Inner Subqueries in the FROM SectionEmployees With More Than Average Salary ChallengeUNION ClauseCombining Table Results
3. Joining Tables
JOIN 2 TablesGet Category By Product PriceGet Minimum Price By CategoryGet Product Amount By CategoryLEFT, RIGHT and INNER JOINsTable Join PracticeFULL JOIN Usage
4. DDL and DML in SQL
CREATE and ConstraintsALTER and INSERT OperationsDROP and TRUNCATEUPDATE and DELETE

bookTable Join Practice

In this task, you'll need to use a different type of JOIN, or you can use the same one you used in the previous chapter, as long as you get the correct result.

Just a reminder, we're working with two tables:

courses:

enrollments:

Task

Write a query to retrieve a list of all students and the courses they are enrolled in, including students who are not enrolled in any course.

Use an appropriate type of JOIN and use the columns in the following order:

As you can see, there are no aliases here, so do not use them to ensure the task is correctly evaluated.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 6
toggle bottom row

bookTable Join Practice

In this task, you'll need to use a different type of JOIN, or you can use the same one you used in the previous chapter, as long as you get the correct result.

Just a reminder, we're working with two tables:

courses:

enrollments:

Task

Write a query to retrieve a list of all students and the courses they are enrolled in, including students who are not enrolled in any course.

Use an appropriate type of JOIN and use the columns in the following order:

As you can see, there are no aliases here, so do not use them to ensure the task is correctly evaluated.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 6
toggle bottom row

bookTable Join Practice

In this task, you'll need to use a different type of JOIN, or you can use the same one you used in the previous chapter, as long as you get the correct result.

Just a reminder, we're working with two tables:

courses:

enrollments:

Task

Write a query to retrieve a list of all students and the courses they are enrolled in, including students who are not enrolled in any course.

Use an appropriate type of JOIN and use the columns in the following order:

As you can see, there are no aliases here, so do not use them to ensure the task is correctly evaluated.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

In this task, you'll need to use a different type of JOIN, or you can use the same one you used in the previous chapter, as long as you get the correct result.

Just a reminder, we're working with two tables:

courses:

enrollments:

Task

Write a query to retrieve a list of all students and the courses they are enrolled in, including students who are not enrolled in any course.

Use an appropriate type of JOIN and use the columns in the following order:

As you can see, there are no aliases here, so do not use them to ensure the task is correctly evaluated.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 3. Chapter 6
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
some-alt