alizarei73SALES per COLLATION
    Updated 2022-07-16
    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
    Run a query to Download Data