SELECT*

from avalanche.core.fact_event_logs join avalanche.core.dim_labels b on address = contract_address

where label_type = 'dex'

select

date_trunc (day, block_timestamp) as date,

project_name,

count(DISTINCT tx_hash) as "Transaction count",

count (distinct origin_from_address) as "Total users"

from tbl1

group by 1,2

ORDER by 1