What correction should be made in the above SQL statement to achieve this?
A. Replace = with the IN operator.
B. Replace = with the >ANY operator.
C. Replace = with the >ALL operator.
D. Remove the GROUP BY clause from the subquery and place it in the main query.
Answer:A
What correction should be made in the above SQL statement to achieve this?
A. Replace = with the IN operator. B. Replace = with the >ANY operator. C. Replace = with the >ALL operator. D. Remove the GROUP BY clause from the subquery and place it in the main query.