ramishoowUntitled Query
    Updated 2023-01-08
    WITH ramishoow as ( SELECT nft_id, COUNT(DISTINCT tx_id) as sales, sum(price) as "sales volume", avg(price) as "average price" FROM flow.core.ez_nft_sales
    WHERE split(nft_collection, '.')[2] LIKE '{{nft_collections}}' AND block_timestamp > CURRENT_DATE - {{first_day}} AND NOT buyer is NULL
    GROUP BY 1 ORDER BY 2 DESC ) SELECT CASE WHEN "sales volume" < 10 THEN 'a $10 Sale Volume' WHEN "sales volume" < 50 THEN 'b Between $10 and $50 Sales Volume' WHEN "sales volume" < 100 THEN 'c Between $50 and $100 Sales Volume'
    WHEN "sales volume" < 1000 THEN 'd Between $100 and $1,000 Sales Volume' WHEN "sales volume" < 10000 THEN 'd Between $1,000 and $10,000 Sales Volume' ELSE 'e Over $10,000 Sales Volume' end as group1, COUNT(*) FROM ramishoow GROUP BY 1 --90
    Run a query to Download Data