SELECT 'NaN' as nan

), universe AS (

SELECT FROM_ADDRESS AS ADDRESS

FROM base.core.fact_transactions

), contracts AS (

SELECT ADDRESS

FROM base.core.dim_contracts

), accounts AS (

SELECT DISTINCT(t1.address)

FROM universe t1

LEFT JOIN contracts t2 ON t2.address = t1.address

WHERE t2.address IS NULL

SELECT COUNT(ADDRESS)

FROM accounts