select distinct

TX_RECEIVER as contracts,

sum (GAS_USED/pow(10,12)) as gas_usedd

from flipside_prod_db.mdao_near.transactions

group by 1

order by 2 DESC

limit 5

select date_trunc('day', block_timestamp::date) as date,

TX_RECEIVER as contracts,

sum (GAS_USED/pow(10,12)) as gas_used

from flipside_prod_db.mdao_near.transactions

inner join Contracts on transactions.TX_RECEIVER=Contracts.contracts

group by 1,2

order by 1