from ethereum.core.fact_transactions

where to_address='0xb4e7b8946fa2b35912cc0581772cccd69a33000c' --Element: Element Swap 2

and eth_value<>0),

tab2 as (select date_trunc('day',block_timestamp) as day, tx_hash, nft_address, project_name,

nft_from_address, nft_to_address, tokenid

from ethereum.core.ez_nft_transfers)

select nft_to_address as "Purchaser", count(distinct tab1.tx_hash) as "purchase Count",

count(distinct project_name) as "Project Count", count(distinct nft_address) as "NFT Count"

from tab1 left join tab2 on tab1.tx_hash=tab2.tx_hash

WHERE project_name IS NOT NULL

group by 1

order by 2 DESC

LIMIT 100