Skip to content

Oct 03: GP2 Feedback, Set Ops

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

Announcements [5 min]

  • Midterm will be next Thu, Oct 10th
    • We will review on Tue, Oct 8th
  • GP2 follow-up meeting with instructor
    • 15-min appointments next week

GP2 Review [40 min]

Section 1 Schedule
Time Instructor Review Peer Feedback Peer Feedback
12:50 PM Team 2: alt T5 reviews T7 T6 reviews T1
12:55 PM Team 3: dfdc " "
1:00 PM Team 4: gg T1 reviews T3 T7 reviews T2
1:05 PM Team 5: tj " "
1:10 PM Team 6: dbs T2 reviews T4
1:15 PM Team 7: databros "
1:20 PM Team 1: goob T3 reviews T5 T4 reviews T6
1:25 PM " "
Section 2 Schedule
Time Instructor Review Peer Feedback Peer Feedback
2:25 PM Team 2: dr T4 reviews T6 T5 reviews T1
2:30 PM Team 3: chefs " "
2:35 PM Team 4: sqls T1 reviews T3
2:40 PM Team 5: legends "
2:45 PM Team 6: bestaurant T2 reviews T4
2:50 PM Team 1: mmm "
2:55 PM T3 reviews T5 T6 reviews T2
3:00 PM " "

Lecture Slides [30 min]

Your To-Do List