• 2022-06-16 问题

    语句delete from eeexam 表明( ). A: 删除eeexam中的全部记录 B: 删除基本表eeexam C: 删除基本表eeexam中的列数据 D: 删除基本表eeexam中的部分行

    语句delete from eeexam 表明( ). A: 删除eeexam中的全部记录 B: 删除基本表eeexam C: 删除基本表eeexam中的列数据 D: 删除基本表eeexam中的部分行

  • 2022-06-01 问题

    查询平均成绩良好,也就是≥80分的考生人数,查询语句就可以写成____。 A: SELECT COUNT(*) FROM ( SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) AS avgach (eeid,avgachieve) WHERE avgachieve>=80; B: SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) avgach (eeid,avgachieve) WHERE avgachieve>=80; C: SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa)FROM departmentWHERE avgachieve>=80; D: SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;

    查询平均成绩良好,也就是≥80分的考生人数,查询语句就可以写成____。 A: SELECT COUNT(*) FROM ( SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) AS avgach (eeid,avgachieve) WHERE avgachieve>=80; B: SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) avgach (eeid,avgachieve) WHERE avgachieve>=80; C: SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa)FROM departmentWHERE avgachieve>=80; D: SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;

  • 2022-06-01 问题

    查询平均成绩良好, 也就是≥80 分的考生人数, 查询语句就可以写成____。 A: SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid) AS avgach (eeid,avgachieve)WHERE avgachieve>=80; B: SELECT COUNT(*)FROM (SELECT eeid,avg(achieve)FROM eeexamGROUP BY eeid) avgach (eeid,avgachieve)WHERE avgachieve>=80; C: SELECT dname,(SELECT COUNT(*)FROM examinerWHERE department.dname = examiner.erdepa)FROM departmentWHERE avgachieve>=80; D: SELECT *FROM erexam NATURAL LEFT OUTER JOIN exampaper;

    查询平均成绩良好, 也就是≥80 分的考生人数, 查询语句就可以写成____。 A: SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid) AS avgach (eeid,avgachieve)WHERE avgachieve>=80; B: SELECT COUNT(*)FROM (SELECT eeid,avg(achieve)FROM eeexamGROUP BY eeid) avgach (eeid,avgachieve)WHERE avgachieve>=80; C: SELECT dname,(SELECT COUNT(*)FROM examinerWHERE department.dname = examiner.erdepa)FROM departmentWHERE avgachieve>=80; D: SELECT *FROM erexam NATURAL LEFT OUTER JOIN exampaper;

  • 1