Subqueries in a Projection clause
A subquery can occur in the Projection clause of another
SELECT statement. The following query shows how you might use a subquery
in a Projection clause to return the total shipping charges (from
the orders table) for each customer in the customer table.
You could also write this query as a join between two tables.