SELECT COUNT(DISTINCT ADDRESS) as new_contracts,

name

FROM base.core.dim_contracts

WHERE name IS NOT NULL

AND symbol IS NULL

group by 2