project_name as "NFT collection",

event_type as "Event Type",

COUNT( DISTINCT tx_hash) AS "transaction count"

FROM arbitrum.nft.ez_nft_sales

WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'

AND project_name IS NOT NULL

GROUP BY project_name, event_type

ORDER BY "transaction count" DESC

LIMIT 10;