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