Can somebody help me on this assignment question?

[piggy]

Thanks for your help first!!!

Thanks for your help first.

4 tables:
Lecturer (ID, name)

Student (ID, name)

Course_offered (course_ID, academic_year, semester, lecturer_ID)
· Lecturer_ID is a foreign key that references the Lecturer table

Course_taken (course_ID, academic_year, semester, student_ID, grade)
· Course_ID, academic_year, semester are a foreign key that references the Course_offered table
· Student_ID is a foreign key that references the Student table.


Question:
List the names of students who have taken course(s) with all the lecturers in the Division.

[bamcorp]

Don't plagurize.

select b.[name]
from
student b inner join course_taken d
on b.[id] = d.student_id
inner join course_offered c
on c.course_id = d.course_id
inner join lecturer a
on a.[id] = c.lecturer_id