View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements:
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
How can statement 2 execute successfully ?
Here having condition is applicable to groups,right ?