SELECT TOP 10 tx_receiver

,sum(gas_used)

FROM flipside_prod_db.mdao_near.transactions

WHERE BLOCK_TIMESTAMP >= DATEADD(day,-30,GETDATE())

and BLOCK_TIMESTAMP <= getdate()

GROUP BY tx_receiver

ORDER BY 2 DESC