SQL Taskbook Level 5.7
The tables are given:
| id | name |
|---|---|
| 1 | Omlet |
| 2 | Fried Eggs |
| 3 | Sausage |
| 4 | Soup |
| 5 | Borsch |
| id | name |
|---|---|
| 1 | Coffee |
| 2 | Cappuccino |
| 3 | Tea |
| 4 | Orange Juice |
| 5 | Milk |
Solve the following problems for them:
Create a meal combination. Choose all meals from the 'meals' table and each meal should have drink options from the 'drinks' table.
Make a combination of dishes. Only drinks must start with the letter 'C' the letter can be either lowercase or uppercase.
Make a combination of dishes. Only drinks must start with any letter except 'c' the letter can be either lowercase or uppercase.
