select case when a.tokenid >= 35000000 and a.tokenid <= 35000299 then 'infiniteyay' when a.tokenid >= 34000000 and a.tokenid <= 34000499 then 'Pop Punk' when a.tokenid >= 33000000 and a.tokenid <= 33000499 then 'Benjamin Bardou' when a.tokenid >= 32000000 and a.tokenid <= 32000499 then 'Chikai' when a.tokenid >= 31000000 and a.tokenid <= 31000500 then 'Seven by RedruM' when a.tokenid >= 30000000 and a.tokenid <= 30000500 then 'corpo | real by Claire Silver' when a.tokenid >= 29000000 and a.tokenid <= 29000500 then 'Ren' when a.tokenid >= 28000000 and a.tokenid <= 28000500 then 'Views by Delta Sauce' when a.tokenid >= 27000000 and a.tokenid <= 27000500 then 'UBK: Ultrabionika by Fernando Jerez' when a.tokenid >= 26000000 and a.tokenid <= 26000500 then 'ClownVamp' when a.tokenid >= 25000000 and a.tokenid <= 25000510 then 'Ira Greenberg' when a.tokenid >= 24000000 and a.tokenid <= 24000500 then 'Ivona Tau' when a.tokenid >= 23000000 and a.tokenid <= 23000500 then 'Kali Yuga' when a.tokenid >= 22000000 and a.tokenid <= 22000500 then 'Daniel Greenwood' when a.tokenid >= 21000000 and a.tokenid <= 21000500 then 'Charlesai' when a.tokenid >= 17000000 and a.tokenid <= 17000999 then 'huemin' when a.tokenid >= 16000000 and a.tokenid <= 16000127 then 'Various Artists' when a.tokenid >= 15000000 AND a.tokenid <= 15000499 then 'Roope Rainisto' when a.tokenid >= 14000000 AND a.tokenid <= 14000128 then 'Van Arman x Mindshift x ricky' when a.tokenid >= 13000000 AND a.tokenid <= 13000499 then 'ATNPassion' when a.tokenid >= 12000000 AND a.tokenid <= 12000512 then 'Entangled Others (Sofia Crespo & Feileacan McCormick)' when a.tokenid >= 11000000 AND a.tokenid <= 11000500 then 'Nikolay Jetchev' when a.tokenid >= 10000000 AND a.tokenid <= 10000500 then 'Artemis' when a.tokenid >= 9000000 AND a.tokenid <= 9000500 then 'Vadim Epstein x COH' when a.tokenid >= 8000000 AND a.tokenid <= 8000499 then 'Heavens Last Angel' when a.tokenid >= 7000000 AND a.tokenid <= 7000999 then 'Obvious' when a.tokenid >= 6000000 AND a.tokenid <= 6000999 then 'Dadabots x Silverstein' when a.tokenid >= 5000000 AND a.tokenid <= 5000999 then 'Devi Parikh' when a.tokenid >= 4000000 AND a.tokenid <= 4000499 then 'Xander Steenbrugge' when a.tokenid >= 3000000 AND a.tokenid <= 3000499 then 'Genesis by Claire Silver' when a.tokenid >= 2000000 AND a.tokenid <= 2001023 then 'Pindar Van Arman' when a.tokenid >= 1000000 AND a.tokenid <= 1000999 then 'Gene Kogan' else null end as artist, sum(creator_fee) as royalties_earned from ethereum.nft.ez_nft_sales a where nft_address = '0xdfde78d2baec499fe18f2be74b6c287eed9511d7' and block_timestamp > '2023-01-01' and currency_symbol in ('ETH', 'WETH') and artist is not null group by 1 order by 2 desc

Query	Creator	Created
glorious-chocolate solana	0xgershon	Sep 4, 2024
raw swaps solana swaps	0xgershon	Sep 16, 2024
braindrops ethereum nft evm	0xgershon	Sep 23, 2024
sol vol solana swaps	0xgershon	Aug 22, 2024
envious-violet solana	0xgershon	Sep 4, 2024

0xgershon