tx_receiver as contract,

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

FROM near.core.fact_transactions

where block_timestamp >= dateadd(week, -1, getdate())

GROUP BY tx_receiver

ORDER BY total_gas DESC

limit 5000