S, c, sc list, I feel the need to use three layers of nested, but don't have any idea,
Help!!!!!!

CodePudding user response:

 select * 
The from s 
Where not the exists (
Select * from sc inner join c on sc. The course number=c # 
Where sc. Student number=s. Student number and c. course name='Java language' 
)