-
Can somebody help me on this assignment question?
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|