ocp 11g認(rèn)證考試題庫(kù)：051-118題，完整題庫(kù)請(qǐng)點(diǎn)擊這里聯(lián)系老師咨詢了解

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