select 
CASE 
when code = 'RLUSD' and meta_issuer_name = 'Ripple' THEN 'RLUDS (Ripple)'
when code = 'USD' and meta_issuer_name = 'GateHub' then 'USD(GateHub)'
when code = 'USD' and meta_issuer_name = 'Bitstamp' then 'USD (Bitstamp)'
when code = 'USDC' and meta_issuer_name = 'Circle' then 'USDC (Circle)'
when code = 'USDT' then 'USDT (Tether)'
ELSE concat(code,'(',coalesce(meta_issuer_name,'UNKNOWN'),')')
end as stablecoin_name,
code as token,
holders
from "@xrpscan.xrp_ledger.tokens"
where (code LIKE'%USD%' OR code='RLUSD')
and holders > 1000
order by holders desc;