OCP-1Z0-051-V9.02-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不能跟列别名

 

sh@TEST0924> SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overhead

  2  FROM promotions

  3  WHERE UPPER(promo_category) IN ('TV', 'INTERNET','POST')

  4  GROUP BY Avg_Cost

  5  ORDER BY Avg_Overhead;

GROUP BY Avg_Cost

         *

ERROR at line 4:

ORA-00904: "AVG_COST": invalid identifier