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?

Question

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?

Answer

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

Answer

statement1
gives an error, statement2 executes successfully

Answer

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

Answer

statement2
gives an error, statement1 executes successfully

Crowdly