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