select

case

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'