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;