View the Exhibit and examine the structure of the PROMOTIONS, SALES, and
CUSTOMER tables. You need to generate a report showing the promo name along with the
customer name for all products that were sold during their promo campaign and before 30th
October 2007. You issue the following query: Which statement is true regarding the above
query?
A.
It produces an error because the join order of the tables is incorrect.
B.
It produces an error because equijoin and nonequijoin conditions cannot be used in the
same SELECT statement.
C.
It executes successfully and gives the required result.
D.
It executes successfully but does not give the required result.