For xyzee solutions

profileMr-G-Stacka

Using the class example database (SQLFUN), create the required SQL statements to produce the following results:

Use a cross join to create a table having all combinations of

  • Ice cream: chocolate, vanilla, coffee, strawberry.
  • Sauce: hot fudge, butterscotch, chocolate.
  • Nuts: peanuts, pecans, almonds, no nuts.
  • Cherry: cherry, no cherry.

First you need to create a table for each of these lists of options (Hint: You will get 96 rows).

    • 10 years ago
    • 15
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      assignment.doc
    Bids(1)