Question

Which statements would execute successfully?
Select one or more:
O SELECT student_name, SUM(subject1)
FROM marks
WHERE student name LIKE'R%;
O SELECT SUM (DISTINCT NVL(subject1,0)), MAX(subject
FROM marks
WHERE subject 1 > subject2;
SELECT SUM (subject 1 +subject2+subject3)
FROM marks
WHERE student name IS NULL
O SELECT student name,subject1
FROM marks
WHERE subject1 > AVG(subject1);​

Answer 1

Explanation:

SELECT student name,subject1

FROM marks

WHERE

Answer 2

Answer:

Query number 1, 3 and 4 will executed successfully.

Explanation:

SELECT SUM (DISTINCT NVL(subject1,0)), MAX(subject

FROM marks

WHERE subject 1 > subject2;

This query  is not going  execute because of