WITH contract AS (SELECT DISTINCT(TX_RECEIVER) , (sum(GAS_USED)/POWER(10,12)) as fees
FROM flipside_prod_db.mdao_near.transactions
WHERE BLOCK_TIMESTAMP::DATE between '2022-06-23' and '2022-07-23'
GROUP BY TX_RECEIVER ORDER BY fees DESC
LIMIT 5)
SELECT BLOCK_TIMESTAMP::DATE AS day ,
TX_RECEIVER ,
(sum(GAS_USED)/POWER(10,12)) as fees
FROM flipside_prod_db.mdao_near.transactions
WHERE BLOCK_TIMESTAMP::DATE between '2022-06-23' and '2022-07-23' AND TX_RECEIVER IN
(SELECT TX_RECEIVER FROM contract)
GROUP BY day , TX_RECEIVER