View the Exhibits and examine the structures of the PROMOTIONS and SALES tables. Evaluate the following SQL statements: Which statement is true regarding the output of the above query?

Question

Exhibit

Options

• AIt gives details of product IDs that have been sold irrespective of whether they had a promo or not
• BIt gives the details of promos for which there have been no sales
• CIt gives the details of promos for which there have been sales
• DIt gives details of all promos irrespective of whether they have resulted in a sale or not

• A
  14% (5)
• B
  3% (1)
• C
  8% (3)
• D
  75% (27)

No community discussion yet for this question.