Contenido del Curso
SQL Intermedio
SQL Intermedio
Práctica de unión de tablas
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 show code editor
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.
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Práctica de unión de tablas
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 show code editor
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.
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones