ocp 11gÈÏÖ¤Ìâ¿â´óÈ«£º1Z0-051-112Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

112. View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

SQL>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?

A. WHERE

B. SELECT

C. GROUP BY

D. ORDER BY

Answer: C

ÊÔÌâ½âÎö£º

group by²»ÄܸúÁбðÃû