Question

Q 26 This statement is erroneous because
SELECT dept_name, ID, avg (salary)
FROM instructor
GROUP BY dept_name;
93-9
Ops: A.
O Avg(salary) should not be selected
B.
O Dept_id should not be used in group by clause
C.
O Misplaced group by clause
D. O none of the mentioned​

Answer 1

Answer:

Answer is option C......