查询选修了C2课的学生号和学生姓名。

参考答案:

SELECT Sno Shame FROM StudentSC WHERE Student. Sno = SC. Sno AND SC. Cno = 'C2'SELECT Sno, Shame FROM Student,SC WHERE Student. Sno = SC. Sno AND SC. Cno =