princefarzamThe popular collections on Coralcube in terms of sales in SOL
    Updated 2022-10-30
    SELECT
    coalesce(address_name,project_name,'Not Labeled Collections') as Collection,
    COUNT(DISTINCT TX_ID) AS number_of_sales,
    sum(SALES_AMOUNT) AS total_sales_in_SOL,
    COUNT(DISTINCT PURCHASER) AS unique_purchaser,
    COUNT(DISTINCT SELLER) AS unique_seller
    FROM solana.core.fact_nft_sales S
    left join solana.core.dim_nft_metadata M on S.mint = M.mint
    left join solana.core.dim_labels L on S.mint = L.address
    WHERE MARKETPLACE = 'coral cube'
    and SUCCEEDED = TRUE
    AND COLLECTION <> 'Not Labeled Collections'
    group by Collection
    order by total_sales_in_SOL DESC
    LIMIT 10