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

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

Examine the following two SQL statements:

Statement 1

SQL>SELECT promo_category,SUM(promo_cost)

FROM promotions

WHERE promo_end_date-promo_begin_date > 30

GROUP BY promo_category;

Statement 2

SQL>SELECT promo_category,sum(promo_cost)

FROM promotions

GROUP BY promo_category

HAVING MIN(promo_end_date-promo_begin_date)>30;

Which statement is true regarding the above two SQL statements?

A. statement 1 gives an error, statement 2 executes successfully

B. statement 2 gives an error, statement 1 executes successfully

C. statement 1 and statement 2 execute successfully and give the same output

D. statement 1 and statement 2 execute successfully and give a different output

Answer:D