Lesson Outline

25 min	Scripts for GP2 * SSH keys setup * GitHub review * Sample scripts
10 min	HW4 Q&A / Hints * #3: join movie_info twice * #4: group by id, not name * #5: look at the person table * #6: "which ones have..."
40 min	Lecture Slides * Aggregation * TPC-H Database * Set operations * Subqueries

Before Tuesday

1. Textbook: Read PDBM 7.3.1.7--11 (9 pages).

2. Project: Finish draft of GP2 (gater data, write DDL).

3. Homework: Keep working on HW4 (due on Sunday).