You now know that once you’ve gathered your information into groups of rows, you can request the MIN, MAX, AVG, SUM, or COUNT of all the values in each group. Suppose you want to refine further the final result set—to focus the groups—by testing one of the aggregate values. Let’s take a look at a simple request.
“Show me the entertainer groups that play in a jazz style and have more than three members.”
Doesn’t sound too difficult, does it? Figure 14-1 shows the tables needed to solve this request.
We again use the “Request/Translation/Clean Up/SQL” technique introduced ...