count(DISTINCT INSTRUCTION:accounts[1]) as NUMBER_OF_USERS

FROM solana.core.fact_events JOIN solana.core.dim_labels on program_id = address

WHERE label_type IN ('defi','dex') AND block_timestamp > '2022-10-01'

GROUP BY 1 ORDER by 2 DESC LIMIT 10)

SELECT date_trunc('day', block_timestamp) as day,label,

count(DISTINCT tx_id) as NUMBER_OF_TRANSACTIONS,

count(DISTINCT INSTRUCTION:accounts[1]) as NUMBER_OF_USERS

FROM solana.core.fact_events JOIN solana.core.dim_labels on program_id = address

WHERE label_type IN ('defi','dex')AND block_timestamp > '2022-10-01'

AND label in (SELECT label from MIN1)GROUP BY 1, 2