Business Analyst: What is a SQL subquery?

1-- Customers who placed orders
2SELECT name FROM customers
3WHERE id IN (SELECT customer_id FROM orders);
4
5-- Customers with above-average orders
6SELECT name FROM customers
7WHERE id IN (
8  SELECT customer_id FROM orders
9  WHERE amount > (SELECT AVG(amount) FROM orders)
10);