Subqueries
A query inside another query.
sql
1SELECT name FROM students
2WHERE marks > (SELECT AVG(marks) FROM students);Students above average marks.

A query inside another query.
1SELECT name FROM students
2WHERE marks > (SELECT AVG(marks) FROM students);Students above average marks.