题目要求是把选修刘老师课程的女同学选课元组全部删去。

DELETE FROM SC2 WHERE Cn IN(SELECT Cn FROM C2 WHERE TEACHER LIKE '刘%') AND Sn IN(SELECT Sn FROM S2 WHERE SEX='女')

我使用了这个语句,但是只删除了后面半句话,这是什么原因?

麻烦大佬帮我看一下

为啥我这边写完这一串,回车后什么也不显示呢
DELETE sc2 from sc2,(SELECT cn FROM c2 WHERE teacher='刘任仁') t1,(SELECT sn FROM s2 WHERE sex='女') t2 WHERE AND sc2.sn=t2.sn