case when contract_address = 'terra1x7rf4nquswmmrjtzlxg6dk3d70ef69prth2q7vk3v9vdprepdh0sjxrvl7' then 'Skeleton Punks'

when contract_address = 'terra17vysjt8ws64v8w696mavjpqs8mksf8s993qghlust9yey8qcmppqnhgw0e' then 'Luna Ape Club'

when contract_address = 'terra1hh9rgaxtmfqfkeqkruckwah6qc4ajlxgnweexyjeh4dsptkfnhmqeelzfl' then 'Ronin'

when contract_address = 'terra16ds898j530kn4nnlc7xlj6hcxzqpcxxk4mj8gkcl3vswksu6s3zszs8kp2' then 'Galactic Punk'

when contract_address = 'terra1zcafgvq74ef8zu5mc62njfprsf3cr33xvan7r4nja269t280djrqkyrjsx' then 'TerraBots' end as collection,

sum(sales_amount/pow(10,decimals)) as luna,

rank() over (order by luna desc ) as rank

from terra.core.fact_nft_sales

where currency = 'uluna'

group by 1,2

qualify rank <= 5