在student、course和sc表的基础上,查询与“数据库基础”课程学分相同的课程的课程名和学分,并且不包含“数据库基础”课程本身,使用( )语句。
A.
select C1.cname,C1.credit from course C1 join course C2 on C1.credit= C2.credit where C2.cname=’ 数据库基础’and C1.cname!=’数据库基础’
B.
select C1.cname,C1.credit from course C1 join course C2 on C1.credit= C2.credit where C2.cname=’ 数据库基础’
C.
select C1.cname,C1.credit from course C1 join course C2 on C1.credit= C2.credit where C1.cname=’ 数据库基础’and C2.cname!=’数据库基础’
D.
select C2.cname,C2.credit from course C1 join course C2 on C1.credit= C2.credit where C2.cname=’ 数据库基础’and C1.cname!=’数据库基础’