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

0xgershon