Challenge: Table Join
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.
Swipe to start coding
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:
enrollments.enrollment_id,
enrollments.student_name,
enrollments.enrollment_date,
courses.course_name,
courses.description
As you can see, there are no aliases here, so do not use them to ensure the task is correctly evaluated.
Brief Instructions
- Retrieve the necessary columns from the
coursestable. - Use a RIGHT JOIN to join the
enrollmentstable. - The common column for both tables is
enrollments.course_id = courses.course_id.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
What types of JOINs can I use in SQL?
Can you explain the difference between INNER JOIN and OUTER JOIN?
How do I decide which JOIN to use for my query?
Awesome!
Completion rate improved to 4Challenge: Table Join
Swipe to show menu
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.
Swipe to start coding
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:
enrollments.enrollment_id,
enrollments.student_name,
enrollments.enrollment_date,
courses.course_name,
courses.description
As you can see, there are no aliases here, so do not use them to ensure the task is correctly evaluated.
Brief Instructions
- Retrieve the necessary columns from the
coursestable. - Use a RIGHT JOIN to join the
enrollmentstable. - The common column for both tables is
enrollments.course_id = courses.course_id.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
single
