CS 330
Lecture 8

Part 1

Examples of SQL queries in Access, using the Sailors database.

Part 2: More SQL, Aggregate operations

Examples for today.

Reading: textbook, Ch. 9.4, all.
Aggregate functions: group by, having.

Make sure you do Hw 3.

Next week: joins; more examples.
Embedded SQL