tx_receiver as contract,

round(sum(gas_used/POW(10,12)),2) as total_gas

FROM near.core.fact_transactions

where block_timestamp >= dateadd(day, -90, getdate())

GROUP BY tx_receiver

ORDER BY total_gas DESC

limit 10