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