select sum (gas_used) / 1e12 as gas_used, sum (transaction_fee) / 1e24 as transaction_fee, tx_receiver as Contract
from flipside_prod_db.mdao_near.transactions where block_timestamp >= CURRENT_DATE - 7 group by Contract order by gas_used desc limit 10