Rather:
select city, zip, count(zip) from masteraccounts group by zip,city order by zip
For more information about this list (including removal) go to: http://www.iea-software.com/support/maillists/liststart