SELECT______(学业分);
PReM学生;
WHERE 科目号 IN;(SELECT 科目号;
F.ROH______;
WHERE 科目号=“法律”)
[试题]使用SQL语句求选修了法律课程的所有学生的学分总和SELECT ___ (学业分);FROM 学生;WHERE 科目号 IN;(SELECT 科目号FROM ___;WHERE 科目号=“法律”)
[试题]使用SQL语句求“工商管理”系的所有职工的工资总和。 SELECT[ ](工资)FROM教师; WHERE系号IN(SELECT系号FROM[ ]WHERE系名=“工商管理”)
[单选题]查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达 时,错误的是( )。A.SELECT SNAME,AGE FROM S WHERE S .S#=(SELECT SC.S# FROM SC WHERE C.C#=’C 1’) B.SELECT SNAME,AGE FROM S,SC WHERE S.S#=SC.S# AND SC.C#=’C 1’ C.SELECT SNAME,AGE FROM S,SC WHERE S.S#=SC.S# AND SC.C#=’C
[主观题]使用SQL语句求“公关部”的所有职工的加班费总和: SELECT___(加班费)FROM值班WHERE部门号INSELECT 部门号FROM___WHERE 部门名=“公关部”;
[单选题]查询选修了课程号为“C2”的学生号和姓名,若用下列SQL的SELECT语句表达时,哪一个是错误的?A.SELECT S.S#,SNAME FROM S WHERE S.S# (SELECT SC. S# FROM SC WHERE C#='C2')B.SELECT S.S#,SNAME FROMS,SC WHERE S.S#=SC.S# AND C#='C2'C.SELECT S.S#,SNAME FROM S,SC WHERE S.S=SC.S# AND C#='C2'ORDER
[单选题]查询选修了课程号为“C2”的学生号和姓名,若用下列SQL的SELECT语句表达是,( )是错误的。 A.SELECT S.S#,SNAME FROM S WHERE S.S# =(SELECT SC.S#FROM SC WHERE C#='C2') B.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2' C.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2'ORDER BY
[单选题]查询选修了课程号为,C2,的学生号和姓名,若用下列SQL的SELECT语句表达时,错误的是( )。A.SELECT S.S#,SNAME FROM S WHERE S.S# =(SELECT SC.S# FROM SC WHERE C#='C2')B.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2')C.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='C2' OR
[单选题]查询选修 C2 课程号的学生姓名,下列 SQL 语句中错误是A.)SELECT 姓名 FROM S WHERE EXISTS (SELECT * FROM SC WHERE 学号 =S. 学号 AND 课程号='C2')B.)SELECT 姓名 FROM S WHERE 学号 IN (SELECT 学号 FROM SC WHERE 课程号 ='C2')C.)SELECT 姓名 FROM S JOIN SC ON S. 学号 =SC. 学号 WHERE 课程号 ='C2'D.)SELE
[单选题]查询选修了课程号为/'C2/'的学生号和姓名,若用下列SQL的SELECT语句表达时,哪一个是错误的?A.SELECT S.S#,SNAME FROM S WHERE S.S#= (SELECT SC.S# FROM SC WHERE C# = 'C2' )B.SELECT S.S#,SNAME FROM S,SCWHERE S.S# = SC.S# AND C# = 'C2'C.SELECT S.S#,SNAME FROM S,SCWHERE S.S# = SC.S# AND C#
[单选题]查询选修了课程号为/'C2/'的学生号和姓名,若用下列SQL的SELECT语句表达时,哪一个是错误的?______。A.SELECT S.S#,SNAME FROM S WHERE S.S#=(SELECT SC.S# FROM SC WHERE C#=/'C2/')B.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#=/'C2/'C.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND