2.3.sql

/*2.3. Hacer un query que liste los nombres de los alumnos enrolados al curso de código a1010.*/

SELECT fullname
FROM
(
  (
    enrollments er
      LEFT JOIN
        students st
    ON er.student_iid = st.student_iid
  )
  AS er_st
    LEFT JOIN
      courses co
  ON er_st.course_iid = co.course_iid
)
AS er_st_co
WHERE er_st_co.code = 'a1010';