A、WITH avgach (eeid,avgachieve) AS (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;
B、WITH avgach (eeid,avgachieve) (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;
C、SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;
D、SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) avgach (eeid,avgachieve) WHERE avgachieve>=80;
E、SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa) FROM department WHERE avgachieve>=80;
F、SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;
第2题
A、db.students.find({"major":"计算机应用技术","score":{$gt:80}}).count()
B、db.students.find({"major":"计算机应用技术","score":{$gte:80}}).count()
C、db.students.find({"major":"计算机应用技术","score":{$gte:80}})
D、db.students.find({$or:[{"major":"计算机应用技术"},{"score":{$gte:80}}]}).count()
第4题
1)根据表查询平均成绩大于等于 60 分的同学的学生编号和学生姓名和平均成绩 2)根据表查询在 SC 表存在成绩的学生信息 实验数据: 学生表: create table Student( Sid varchar(6), Sname varchar(10), Sage datetime, Ssex varchar(10)); insert into Student values('01' , '赵雷' , '1990-01-01' , '男'); insert into Student values('02' , '钱电' , '1990-12-21' , '男'); insert into Student values('03' , '孙风' , '1990-05-20' , '男'); insert into Student values('04' , '李云' , '1990-08-06' , '男'); insert into Student values('05' , '周梅' , '1991-12-01' , '女'); insert into Student values('06' , '吴兰' , '1992-03-01' , '女'); insert into Student values('07' , '郑竹' , '1989-07-01' , '女'); insert into Student values('08' , '王菊' , '1990-01-20' , '女') 成绩表 create table SC( Sid varchar(10), Cid varchar(10), score decimal(18,1)); insert into SC values('01' , '01' , 80); insert into SC values('01' , '02' , 90); insert into SC values('01' , '03' , 99); insert into SC values('02' , '01' , 70); insert into SC values('02' , '02' , 60); insert into SC values('02' , '03' , 80); insert into SC values('03' , '01' , 80); insert into SC values('03' , '02' , 80); insert into SC values('03' , '03' , 80); insert into SC values('04' , '01' , 50); insert into SC values('04' , '02' , 30); insert into SC values('04' , '03' , 20); insert into SC values('05' , '01' , 76); insert into SC values('05' , '02' , 87); insert into SC values('06' , '01' , 31); insert into SC values('06' , '03' , 34); insert into SC values('07' , '02' , 89); insert into SC values('07' , '03' , 98) 课程表 create table Course( Cid varchar(10), Cname varchar(10), Tid varchar(10)); insert into Course values ('01' , '语文' , '02'); insert into Course values ('02' , '数学' , '01'); insert into Course values ('03' , '英语' , '03') 教师表 create table Teacher( Tid varchar(10), Tname varchar(10)); insert into Teacher values ('01' , '张三'); insert into Teacher values ('02' , '李四'); insert into Teacher values ('03' , '王五')
第5题
查询各科成绩最高分、最低分和平均分: 以如下形式显示: -- 课程 ID,课程 name,最高分,最低分,平均分,及格率,中等率,优良率,优秀率 -- 及格为>=60,中等为:70-80,优良为:80-90,优秀为:>=90 -- 要求输出课程号和选修人数,查询结果按人数降序排列,若人数相同,按课程号升序排列 select sc.CId, max(sc.score) as '最高分', min(sc.score) as '最低分', avg(sc.score) as '平均分', count(*) as '选修人数', sum(case when sc.score >= 60 then 1 else 0 end)/count(*) as '及格率', sum(case when sc.score >= 70 and sc.score < 80 then 1 else 0 end)/count(*) as '中等率', sum(case when sc.score >= 80 and sc.score < 90 then 1 else 0 end)/count(*) as '优良率', sum(case when sc.score >= 90 then 1 else 0 end)/count(*) as '优秀率' from sc group by sc.CId order by count(*) DESC, sc.CId ASC
第6题
A.795
B.875
C.1007
D.1264
第7题
(1)用SQL语句查询“成绩”在80分以上(包括80分)的学生姓名,并将结果按学号升序存入表文件“resuh.dbf”中,将SQL语句保存在考生文件夹下的“result.txt”文本中。
(2)使用表单向导制作一个表单。要求:选择“student”表中的全部字段,表单样式为“彩色式”,按钮类型为“文本按钮”,排序字段选择“学号”(升序),表单标题为“学生信息浏览”,最后将表单保存为“bd1”。
第8题
A.学生信息表S
B.学生信息表S和课程信息表c
C.学生信息表S、课程信息表c和学生选课信息表sc
D.学生信息表S和学生选课信息表sc
第9题
A.学生信息表S
B.学生信息表S和课程信息表c
C.学生信息表S、课程信息表c和学生选课信息表sc
D.学生信息表S和学生选课信息表sc
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!