# SQL Notes: Exercise 4 - SELECT Summaries

Name: __________________________________________

Write a SELECT statement which produces the results. Put each clause (FROM, WHERE, ...) on a separate line. Unless otherwise specified, use the example database from the book SQL: The Complete Reference.

1. How many offices are there?

2. How many office managers are there? Remember that some managers may manage more than one office/person.

3. When was Sue Smith's first sale?

4. What's the biggest order each salesrep has taken? List the rep (number) and the amount.

5. Who are the reps (name) who have made exactly one sale?