select sid,sname
from Student st
where (
select count(*)
from SC sc
Where st.sid=sc.sid
) < (Select Count(*) From Course);
Student表:
SC表:
Teacher表:
Course表:
select sid,sname
from Student st
where (
select count(*)
from SC sc
Where st.sid=sc.sid
) < (Select Count(*) From Course);
Student表:
SC表:
Teacher表:
Course表: