oracle problem
The question is "Which other lecturers teach on exactly the same set of modules as 'Jan'; no more or less"
Here is my code:
select teach.lecturer_name "Lecturer Name" from teach
where teach.module_code in
(select module_code from teach
where lecturer_name='Jan')
intersect
select lecturer_name from lecturer
where lecturer_name<>'Jan';
The result came out was the lecturers who teach the same modules as Jan, but it could be more or less. it does not really match the question.
Please help... Thanks..!!
|