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

##</code><code>##

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