This statement is erroneous because
A. Avg(salary) should not be selected
B. Dept_id should not be used in group by clause
C. Misplaced group by clause
D. Group by clause is not valid in this query
Answer:A
This statement is erroneous because
A. Avg(salary) should not be selected B. Dept_id should not be used in group by clause C. Misplaced group by clause D. Group by clause is not valid in this query