$query = "select zipcount from table where id = emailid and address !=\"\" and first != \"\" group by c.z5" ;