• 2022-10-26 问题

    ‌下列SQL语句中,_____________可以在“学生-课程”数据库正确实现“查询学生201215012选修课程的总学分数”。‏ A: SELECT COUNT(Ccredit)FROM SC, CourseWHER Sno='201215012' B: SELECT COUNT(Ccredit)FROM SC, CourseWHER Sno='201215012' AND SC.Cno=Course.Cno C: SELECT SUM(Ccredit)FROM SC, CourseWHER Sno='201215012' D: SELECT SUM(Ccredit)FROM SC, CourseWHER SC.Cno=Course.Cno AND Sno='201215012'

    ‌下列SQL语句中,_____________可以在“学生-课程”数据库正确实现“查询学生201215012选修课程的总学分数”。‏ A: SELECT COUNT(Ccredit)FROM SC, CourseWHER Sno='201215012' B: SELECT COUNT(Ccredit)FROM SC, CourseWHER Sno='201215012' AND SC.Cno=Course.Cno C: SELECT SUM(Ccredit)FROM SC, CourseWHER Sno='201215012' D: SELECT SUM(Ccredit)FROM SC, CourseWHER SC.Cno=Course.Cno AND Sno='201215012'

  • 1