View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement:
The above query generates an error on execution.
Which clause in the above SQL statement causes the error?
A.
WHERE
B.
SELECT
C.
GROUP BY
D.
ORDER BY
You can not use aliases in GROUP BY clause.