109.Examine the structure of the MARKS table:

109.Examine the structure of the MARKS table:
name             Null        Type
STUDENT_ID       NOT NULL    VARCHAR2(4)
STUDENT_NAME                 VARCHAR2(25)
SUBJECT1                     NUMBER(3)
SUBJECT2                     NUMBER(3)
SUBJECT3                     NUMBER(3)
Which two statements would execute successfully? (Choose two.)
A.SELECT student_name,subject1 FROM marks WHERE subject1 > AVG(subject1);
B.SELECT student_name,SUM(subject1) FROM marks WHERE student_name LIKE 'R%';
C.SELECT SUM(subject1+subject2+subject3) FROM marks WHERE student_name IS NULL;
D.SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) FROM marks WHERE subject1 > subject2;
答案：CD
解析：
A.错误，首先,avg不能直接使用在where中，除非一个完整的select语句，或者改成having，那么就需要group by
B.错误，sum是聚合函数，通过条件可知，是满足student_name LIKE 'R%'这个条件的所有的行总数，
但是select中student_name可能并不一定是一样的，即使一样，也不能这样用，这里要么使用group by，
要么去掉select中的student_name
C:正确
D:正确