farid-c9j0VMUntitled Query
    Updated 2022-07-26
    with base as (select date(BLOCK_TIMESTAMP) as date,
    tx_receiver,
    sum(GAS_USED/1e12) as gasd,
    1 as numbering,
    sum(numbering) over (partition by date order by gasd desc) as filtering
    from flipside_prod_db.mdao_near.transactions
    where date>= CURRENT_DATE-7
    group by 1,2)

    select *
    from base
    where filtering <10
    order by 3 desc
    Run a query to Download Data