project_name as "Project",

nft_address as "Contract Address",

max(block_timestamp) as "Most Recent Trade",

count(distinct tx_hash)::int as "Transactions",

count(tokenid)::int as "NFTs Traded",

count(case when buyer_address in (

lower('{{Wallet1}}')

,lower('{{Wallet2}}')

,lower('{{Wallet3}}')

,lower('{{Wallet4}}')

,lower('{{Wallet5}}')

,lower('{{Wallet6}}')

)

then 1 end)::int

as "Bought",

count(case when seller_address in (

lower('{{Wallet1}}')

,lower('{{Wallet2}}')

,lower('{{Wallet3}}')

,lower('{{Wallet4}}')

,lower('{{Wallet5}}')

,lower('{{Wallet6}}')

)

then 1 end)::int

as "Sold",

('$'|| to_char(max(case when buyer_address in (

lower('{{Wallet1}}')

,lower('{{Wallet2}}')

,lower('{{Wallet3}}')

,lower('{{Wallet4}}')

,lower('{{Wallet5}}')

,lower('{{Wallet6}}')

)

then price_usd end),'999,999D99'))

as "Most Paid",