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

What if we want to get only specific entries from our data? The WHERE clause can be used after the FROM clause to add conditions to what data is retrieved, like so:

SELECT *
FROM FOOD_NAME
WHERE column operator value;

• column contains the value we want to test
• operator is the type of comparison (e.g., =, <, >, <=, >=)
• value is the value we want to match (e.g., a number)

Only data where the WHERE clause is true will be retrieved.

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