题目内容

Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ3 NUMBER(3) SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? ()

A. SELECT SUM(subj1, subj2, subj3) FROM marks;
B. SELECT SUM(subj1 + subj2 + subj3) FROM marks;
C. SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;
D. SELECT MAX(subj1, subj2, subj3) FROM marks;
E. SELECT MINIMUM(subj1) FROM marks;
F. SELECT COUNT(std_id) FROM marks WHERE subj1 >= AVG(subj1)

查看答案
更多问题

简述硫化氢的化学性质?

常用的破碎方法有哪几种?

投资银行主要服务于货币市场

A. 正确
B. 错误

包裹申请修正名址后,其费用如何处理?

答案查题题库