Courses / SQL Essentials / Lesson 1

1. Tables, rows and SELECT

Every programmer starts here. In this lesson you write a complete program, run it, and change it until it does what you want.

JOINssql

SELECT c.name, o.ordered_at, o.total
FROM customers AS c
JOIN orders AS o ON o.customer_id = c.id
WHERE o.total > 100
ORDER BY o.ordered_at DESC
LIMIT 10;

Your turn

Change the program so it greets you by name, then run it in the playground. The checks turn green when the output matches.

Open the playground Next lesson →