Subject Re: Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)

Except that grouping by OPS_ZIP would not accomplish the same thing. Multiple zip codes map to the same REGION_ID and the zip codes might not be contiguous.

Guess I'm going to have to rethink this.