// lesson 2 of 12 · 16 min

SELECT, WHERE, and ORDER BY

SELECT title, price
FROM courses
WHERE level = 'beginner'
ORDER BY price ASC;

SELECT chooses columns, FROM chooses the table, WHERE filters rows, ORDER BY sorts the result. Common WHERE patterns:

WHERE price > 50
WHERE level IN ('beginner', 'intermediate')
WHERE title LIKE '%Python%'
WHERE price BETWEEN 30 AND 100

SELECT * grabs every column — fine for exploring, but in real application code, name the columns you actually need.

Try it yourself

Exercise: Using the courses table below, write a SELECT for title and price where level = 'beginner', ordered by price ascending.

Expected output: open-ended — there's no single correct output here, just get your code running without errors.

sqlite3

Output

Run your code and get it working before marking this lesson complete.

// free preview

9 more lessons — including Project: design a small course-platform schema — plus a certificate are waiting.

← Previous Log in to track progress