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表：