Examine the structure of the MARKS table:
Which two statements would execute successfully? (Choose two.)
A. SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)
FROM marks
WHERE subject1 > subject2;
B. SELECT student_name subject1
FROM marks
WHERE subject1 > AVG(subject1);
C. SELECT SUM(subject1+subject2+subject3)
FROM marks
WHERE student_name IS NULL;
D. SELECT student_name,SUM(subject1)
FROM marks
WHERE student_name LIKE ‘R%’;
AC
B is wrong because there are aggregate function in WHERE
D is wrong because in this case STUDENT_NAME must be placed in GROUP BY too
AC is correct, I executed all statements.