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