← All lessons lesson_18 · 18 of 31

Nested queries

← Prev Next →

exercise

Lesson 18 of 31

Nested queries

In SQL, you can put a SQL query inside another SQL query.

For example, to find the family members with the least number of legs,
you can run:
SELECT * FROM family_members WHERE num_legs = (SELECT MIN(num_legs) FROM family_members);

The SELECT query inside the parentheses is executed first, and returns the minimum number of legs. Then, that value (2) is used in the outside query, to find all family members that have 2 legs.

Can you return the family members that have the highest num_books_read?

available tables

Loading…

your-query.sql

Ctrl + ⏎ ready

Press Run query to see your result.