SELECT
a.LABEL as "COLLATION",
COUNT(DISTINCT(b.tx_id)) as "sales"
FROM flipside_prod_db.polygon.labels a
JOIN flipside_prod_db.polygon.transactions b
on a.ADDRESS = b.TO_ADDRESS
WHERE a.LABEL LIKE '%opensea%' or a.LABEL LIKE '%nft%'
GROUP by 1
ORDER BY 2 DESC