Crowdly
Add to Chrome
Evaluate the following SQL statement: SELECT promo_category, AVG(promo_cost...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Evaluate the following SQL statement:
SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overhead
FROM promotions
WHERE UPPER(promo_category) IN ('TV', 'INTERNET','POST')
GROUP BY Avg_Cost ORDER BY Avg_Overhead;
The above query generates an error on execution.
Which clause in the above SQL statement causes the error?
0%
0%
0%
0%