with mints as(

from_address as nft_contract,

name,

symbol,

tx_hash as mint_tx,

eth_value as earning

from base.core.fact_traces t inner join base.core.dim_contracts l

on t.from_address = l.address

where to_address = '0x7777777f279eba3d3ad8f4e708545291a6fdba8b'

and tx_status = 'SUCCESS'

),

minters as (

select

from_address as minter,

to_address

from base.core.fact_traces t2 inner join mints m

on t2.to_address = m.nft_contract

select

nft_contract,

name,

symbol,

sum(earning)

from mints m inner join minters mi on m.nft_contract = mi.to_address

where nft_contract in ('0x7d5861cfe1c74aaa0999b7e2651bf2ebd2a62d89')

group by 1,2,3

order by 4 DESC