Oct 27: Subqueries

Learning Objectives

After today's class, you should be able to:

• Write subqueries in the FROM clause and the WHERE clause.
• Rewrite a subquery as a join, and explain when each approach is clearer.