>My interpretation of the documentation is that all fields that are not calculated must be included in the group by clause. So if the old SQL statement were:
Carole Shaw
Fred Hutchinson Cancer Research Center
Eagles may soar, but weasels don't get sucked into jet engines.