Prática de Junção de Tabelas
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
courses
table. - Use a RIGHT JOIN to join the
enrollments
table. - The common column for both tables is
enrollments.course_id = courses.course_id
.
Solução
Obrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Awesome!
Completion rate improved to 4
Prática de Junção de Tabelas
Deslize para mostrar o 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
courses
table. - Use a RIGHT JOIN to join the
enrollments
table. - The common column for both tables is
enrollments.course_id = courses.course_id
.
Solução
Obrigado pelo seu feedback!
Awesome!
Completion rate improved to 4single