WHERE: Filtering Rows

WHERE keeps only the rows that match a condition. Text goes in single quotes; numbers do not.

Examplesql

Comparison operators: =, <> (not equal), <, >, <=, >=.

Examplesql

Quick check

Which query finds products that cost less than 5?

SELECT * FROM products WHERE price = 5;SELECT * FROM products WHERE price < 5;SELECT * FROM products IF price < 5;

Your turn: write the code

Write a query that returns the name of every customer older than 30, sorted by name.

Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.

Tip: use the left and right arrow keys to move between lessons.