SELECT

DISTINCT CAST(value AS VARCHAR) AS users, -- Explicitly casting to VARCHAR

MIN(trunc(b.block_timestamp, 'week')) AS debut

FROM

flow.core.ez_transaction_actors AS b,

LATERAL FLATTEN(INPUT => b.actors) AS a -- Flattening the actors array

GROUP BY 1

UNION ALL

SELECT

DISTINCT from_address AS users,

MIN(trunc(block_timestamp, 'week')) AS debut

FROM

flow.core_evm.fact_transactions

GROUP BY 1

),

news2 AS (

SELECT

debut,

COUNT(DISTINCT users) AS new_users

FROM

news

GROUP BY debut

),

actives AS (

SELECT

trunc(b.block_timestamp, 'week') AS week,

COUNT(DISTINCT CAST(value AS VARCHAR)) AS active_users -- Explicitly casting to VARCHAR

FROM

flow.core.ez_transaction_actors AS b,

LATERAL FLATTEN(INPUT => b.actors) AS a -- Flattening the actors array

GROUP BY 1

UNION ALL