with tb AS (select

distinct tx_hash,

BLOCK_TIMESTAMP,

TX_FEE,

NFT_TO_ADDRESS,

NFT_Address

from ethereum.core.ez_nft_mints where EVENT_TYPE='nft_mint')

select

date_trunc('month',BLOCK_TIMESTAMP) AS MONTH,

sum(TX_FEE) AS "Fee amount",

Avg(TX_FEE) AS "Average Fee amount"

from tb where BLOCK_TIMESTAMP >= '2022-01-01'

group by 1