Feb 27: Subqueries, Set Operations

Learning Objectives

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

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

Lesson Outline

HW5 Debrief [15 min]

• See the Sample Solution on Canvas
• Other ways of running psql/meld

Lecture Slides [30 min]

• SQL Queries: Subqueries and Set Operations
• Demo queries on the slides and other examples

Lab Activity [30 min]

• The postgres_air database
• Discuss solutions as a class

Your To-Do List

• Start reading zyBook sections 3.5 – 3.9
• Start working on Homework 6 (due Monday)
  • Last assignment before the midterm