（118）View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements:

-- Statement 1

SELECT promo_category, SUM(promo_cost) FROM promotions

WHERE promo_end_date-promo_begin_date > 30 GROUP BY promo_category;

--Statement 2

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?

答案：（D）

解析：

HAVING子句中可以出现SELECT子句中没有出现的聚合函数。

ITPub博客

OCP 1Z0-051-118