Managing Data with SQL: Exercises

Exercise 1: SELECT

In SQL Online, type the following query and click "Run":

SELECT *
FROM FOOD_NAME

Exercise 2: WHERE

Exercise 2A

Exercise 2B

Exercise 2C

Exercise 2D

Exercise 3: Matching text with LIKE

Exercise 3A

Exercise 3B

Exercise 4: ORDER BY

Exercise 4A

Exercise 4B

Exercise 5: GROUP BY

Exercise 6: JOIN

Exercise 7: Table aliases

Stretch Exercise(s)

More than one JOIN

Challenge Problems

Challenge 1: Critical groups

Challenge 2: I want my greens!

Challenge 3: Zigzag meal plan

Challenge 4: No leftovers!

Challenge 4B: Leftovers = PROFIT