For xyzee solutions
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)![blurred-text]()
![]()
Purchase the answer to view it

- assignment.doc
Bids(1)