lesson

SQL Queries

11 / 30

40 minlesson

You completed the free preview — you are ready for the full path.

All lessons are readable below. To write and run code from lesson 11 onwards, upgrade to Path Plus ($9/mo) or Pro.

1 min read

SQL Queries: SELECT, WHERE, ORDER BY, LIMIT

Structured Query Language (SQL) is the standard language for interacting with relational databases. In this lesson you will practice reading data with SELECT.

Core Clauses

SELECT — chooses the columns to return.
FROM — names the table to read from.
WHERE — filters rows with a condition.
ORDER BY — sorts the result set.
LIMIT — restricts how many rows are returned.

Example

sql

SELECT name, age FROM users WHERE age > 21 ORDER BY age DESC LIMIT 2;

The Database

This sandbox contains three tables:

users(id, name, email, age)
posts(id, user_id, title, body)
comments(id, post_id, user_id, body)

Your Task

Write a query that returns the name and email of all users older than 30, ordered by name ascending.

You completed the free preview — you are ready for the full path.

All lessons are readable below. To write and run code from lesson 11 onwards, upgrade to Path Plus ($9/mo) or Pro.

1 min read

SQL Queries: SELECT, WHERE, ORDER BY, LIMIT

Structured Query Language (SQL) is the standard language for interacting with relational databases. In this lesson you will practice reading data with SELECT.

Core Clauses

SELECT — chooses the columns to return.
FROM — names the table to read from.
WHERE — filters rows with a condition.
ORDER BY — sorts the result set.
LIMIT — restricts how many rows are returned.

Example

sql

SELECT name, age FROM users WHERE age > 21 ORDER BY age DESC LIMIT 2;

The Database

This sandbox contains three tables:

users(id, name, email, age)
posts(id, user_id, title, body)
comments(id, post_id, user_id, body)

Your Task

Write a query that returns the name and email of all users older than 30, ordered by name ascending.

1 min read

SQL Queries: SELECT, WHERE, ORDER BY, LIMIT

Structured Query Language (SQL) is the standard language for interacting with relational databases. In this lesson you will practice reading data with SELECT.

Core Clauses

SELECT — chooses the columns to return.
FROM — names the table to read from.
WHERE — filters rows with a condition.
ORDER BY — sorts the result set.
LIMIT — restricts how many rows are returned.

Example

sql

SELECT name, age FROM users WHERE age > 21 ORDER BY age DESC LIMIT 2;

The Database

This sandbox contains three tables:

users(id, name, email, age)
posts(id, user_id, title, body)
comments(id, post_id, user_id, body)

Your Task

Write a query that returns the name and email of all users older than 30, ordered by name ascending.

1 min read

SQL Queries: SELECT, WHERE, ORDER BY, LIMIT

Structured Query Language (SQL) is the standard language for interacting with relational databases. In this lesson you will practice reading data with SELECT.

Core Clauses

SELECT — chooses the columns to return.
FROM — names the table to read from.
WHERE — filters rows with a condition.
ORDER BY — sorts the result set.
LIMIT — restricts how many rows are returned.

Example

sql

SELECT name, age FROM users WHERE age > 21 ORDER BY age DESC LIMIT 2;

The Database

This sandbox contains three tables:

users(id, name, email, age)
posts(id, user_id, title, body)
comments(id, post_id, user_id, body)

Your Task

Write a query that returns the name and email of all users older than 30, ordered by name ascending.