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).
Posted: 4 years ago
Due: 20/03/2016
Budget: $15