SELECT X.SID
FROM CHOICES AS X,CHOICES AS Y
WHERE X.CID=(
       SELECT CID
       FROM COURSES
       WHERE CNAME='c++'
      ) AND X.SID=Y.SID AND NOT (
      Y.CID=(
             SELECT CID
             FROM COURSES
             WHERE CNAME='java'
)
)