查询选修了a001课程的学生的学号，姓名，系，专业，所选课程的课程号、课程名和成绩

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’

正确答案：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’