table_1 AS (

SELECT

a.tx_hash AS tx

, count( DISTINCT a.tokenid ) AS total_tx

FROM

avalanche.nft.ez_nft_transfers a

WHERE

a.nft_address = '0x7098b1918eb2aa13945b8a489975bbbf0d5dd79b'

AND a.event_type = 'mint'

GROUP BY 1

,

table_2 AS (

SELECT

a.block_timestamp AS date

, a.tx_hash AS transactions

, a.nft_to_address AS minter

, a.tokenid AS token_ids

, b.amount / c.total_tx AS avax_amount

, b.amount_usd / c.total_tx AS usd_dollars

FROM

avalanche.nft.ez_nft_transfers a

LEFT JOIN

avalanche.core.ez_native_transfers b

ON a.tx_hash = b.tx_hash

AND a.nft_to_address = b.from_address

LEFT JOIN

table_1 c

ON a.tx_hash = c.tx

WHERE

a.nft_address = '0x7098b1918eb2aa13945b8a489975bbbf0d5dd79b'

AND a.event_type = 'mint'

ORDER BY 4 ASC