select label, avg(n_txn) as avg_txn_nft from (select label, from_address, count(tx_hash) as n_txn from (with

mm as (select distinct from_address from ethereum.core.fact_transactions where to_address=lower('0x881d40237659c251811cec9c364ef91dc08d300c') ),

txn as (select mm.from_address, tx_hash, to_address from ethereum.core.fact_transactions as ft inner join mm on mm.from_address=ft.from_address)

select from_address, tx_hash, ADDRESS, ADDRESS_NAME, LABEL_TYPE, LABEL from ethereum.core.dim_labels as l inner join txn on txn.to_address=l.address)

where label_type='nft'

group by 1,2 order by 3)

group by 1 order by 2 desc

limit 10