A.
select * from student,course,sc where sudent.sid=sc.sid and course.cid=sc.sid and cid=‘a001’
B.
select sid,sname,depart,zhuanye,cid,cname,grade from student,course,sc where student.sid=sc.sid and course.cid=sc.sid and cid=a001
C.
select student.sid,sname,depart,zhuanye,cid,cname,grade from student,course,sc where student.sid=sc.sid and course.cid=sc.sid and cid=‘a001’
D.
select student.sid,sname,depart,zhuanye,course.cid,cname,grade from student,course,sc where student.sid=sc.sid and course.cid=sc.sid and cid=‘a001’