platform_name as marketplaces,

CASE

WHEN CREATOR_FEE_USD = 0 THEN '0% Royalty'

WHEN CREATOR_FEE_USD BETWEEN 0 AND 5 THEN '0-$5 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 5 AND 10 THEN '$5-$10 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 10 AND 50 THEN '$10-$50 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 50 AND 100 THEN '$50-$100 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 100 AND 500 THEN '$100-$500 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 500 AND 1000 THEN '$500-$1,000 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 1000 AND 10000 THEN '$1,000-$10,000 Royalty'

WHEN CREATOR_FEE_USD BETWEEN 10000 AND 999999999 THEN '$10,000+ Royalty'

END as status,

COUNT(DISTINCT TX_HASH) as "Sales Count"

FROM ethereum.core.ez_nft_sales

WHERE PLATFORM_NAME ='blur'

AND block_timestamp::DATE >= '2022-10-20'

and status is not null

GROUP BY 1, 2

ORDER BY 1, 2