A subquery is a query nested inside another query. It is used to retrieve data from multiple tables or perform complex calculations.

• A subquery is enclosed within parentheses and is usually placed with...read more

SELECT customer_name, ( SELECT SUM(order_total) FROM orders WHERE orders.customer_id = customers.customer_id ) as total_orders FROM customers WHERE customer_name LIKE '%John%';