kitlunaPlay Types of Top Shots Collection/Total Sales Number and Volume
    Updated 2022-07-26
    SELECT
    COUNT (DISTINCT (a.TX_ID)) AS sales_number,
    SUM (PRICE) AS sales_volume,
    AVG (PRICE) AS avg_price,
    MAX (PRICE) AS max_price,
    MIN (PRICE) AS min_price,
    PLAY_TYPE
    FROM flow.core.fact_nft_sales a
    LEFT JOIN flow.core.dim_topshot_metadata b
    ON a.NFT_ID = b.NFT_ID
    WHERE a.NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot' AND TX_SUCCEEDED = 'TRUE' AND PLAY_TYPE IS NOT NULL
    GROUP BY PLAY_TYPE
    Run a query to Download Data