WITH all_txs AS (
SELECT
TX_HASH
FROM
base.core.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS = lower('0x07f4ae64f236eacf81b4d798f0c6daf9d29e9cf3')
AND
CONTRACT_ADDRESS = lower('0xc16706ae5eed1805990d92241add1662724e50f2')
)
SELECT
SUM(ETH_VALUE) AS total_eth,
SUM(TX_FEE) AS total_fees,
total_eth/100 AS nft_price,
total_fees/(SELECT count(DISTINCT(TX_HASH)) FROM all_txs) AS avg_fee
FROM
base.core.fact_transactions
WHERE
TX_HASH IN (SELECT TX_HASH FROM all_txs)