Mar 31: Set Ops & Subqueries

Learning Objectives

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

• Write subqueries in the FROM clause and the WHERE clause.
• Connect two queries with UNION, INTERSECT, and EXCEPT.

Lesson Outline

Lecture Slides [35 min]

• Subqueries and Set Operations
• [40 min] Queries on the "air" database

Your To-Do List

• Read Section 1.8 in the book