1select 
2CASE 
3when code = 'RLUSD' and meta_issuer_name = 'Ripple' THEN 'RLUSD (Ripple)'
4when code = 'USD' and meta_issuer_name = 'GateHub' then 'USD(GateHub)'
5when code = 'USD' and meta_issuer_name = 'Bitstamp' then 'USD (Bitstamp)'
6when code = 'USDC' and meta_issuer_name = 'Circle' then 'USDC (Circle)'
7when code = 'USDT' then 'USDT (Tether)'
8ELSE concat(code,'(',coalesce(meta_issuer_name,'UNKNOWN'),')')
9end as stablecoin_name,
10code as token,
11holders
12from "@xrpscan.xrp_ledger.tokens"
13where (code LIKE'%USD%' OR code='RLUSD')
14and holders > 1000
15order by holders desc;