Subqueries
Write queries inside other queries to solve complex data problems.
Subqueries
Subqueries can be used inside SELECT, WHERE, FROM, and other SQL clauses.
sql
SELECT name
FROM students
WHERE course_id = (
SELECT id FROM courses WHERE title = 'SQL Basics'
);