Об'єднання Таблиц Челендж
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.
Рішення
Дякуємо за ваш відгук!
single
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
What types of JOINs are there in SQL?
Can you give an example of using a different JOIN type?
How do I decide which JOIN to use for a specific problem?
Awesome!
Completion rate improved to 4Об'єднання Таблиц Челендж
Свайпніть щоб показати меню
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.
Рішення
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
Awesome!
Completion rate improved to 4single
