entity_name,

weekly_fees_usd,

weekly_fees_usd / n_transactions as fee_per_txn

from

(select date_trunc('week',block_timestamp) as week,

from_label as entity_name,

sum(fee_usd) as weekly_fees_usd,

count( distinct tx_id ) as n_transactions

from gold.ethereum_transactions

block_timestamp > getdate() - interval '16 weeks'

AND from_label IS NOT NULL

AND from_label_subtype = 'distributor_cex'

GROUP BY 1,2

ORDER BY 1 DESC, 3 DESC) feeeeee

where feeeeee.weekly_fees_usd > 80000

and week < '2021-02-22';