barbodOverall - Assessment
    Updated 2022-04-30
    with tt as (select
    s.event_inputs:token as tkn,
    b.label as token_name,
    s.event_inputs:vault,
    sum(s.event_inputs:price)/1e18 as sale_price
    from Ethereum_core.fact_event_logs s
    left join ethereum_core.dim_labels b on s.event_inputs:token::string = b.address
    where contract_address = lower('0x85aa7f78bdb2de8f3e0c0010d99ad5853ffcfc63')
    and event_name = 'Mint'
    and block_timestamp > CURRENT_DATE - 90
    group by 1, 2, 3
    )

    select sum(sale_price) as total_trading_Volume ,count(tkn) as number_NFT from tt
    Run a query to Download Data