remove group by clause to prevent some city, county, and zips from being removed