SELECT sname FROM student,sc,course
wjere student.sno = `SCHEMA`().sno and sc.cno = course.cno
SELECT sname FROM student WHERE
exists(
wjere student.sno = `SCHEMA`().sno and sc.cno = course.cno
SELECT sname FROM student WHERE
exists(
SELECT * FROM WHERE sno=student.sno and cno=1)
select sname
FROM studentwhere sno in(
SELECT sno
FROM sc
WHERE cno in(
SELECT cno
FROM course
where cname like "%数据库基础"
)
)