1WITH ranked_stablecoins AS (
2    SELECT 
3        CASE 
4            WHEN code = 'RLUSD' AND meta_issuer_name = 'Ripple' THEN 'RLUSD (Ripple)'
5            WHEN code = 'USD' AND meta_issuer_name = 'GateHub' THEN 'USD (GateHub)'
6            WHEN code = 'USD' AND meta_issuer_name = 'Bitstamp' THEN 'USD (Bitstamp)'
7            WHEN code = 'USDC' AND meta_issuer_name = 'Circle' THEN 'USDC (Circle)'
8            WHEN code = 'USDT' THEN 'USDT (Tether)'
9            ELSE CONCAT(code, ' (', COALESCE(meta_issuer_name, 'UNKNOWN'), ')')
10        END AS stablecoin_name,
11        code AS token,
12        supply AS total_supply,
13        holders,
14        ROUND(supply, 2) AS supply_rounded,
15        ROW_NUMBER() OVER (ORDER BY supply DESC) AS supply_rank
16    FROM @xrpscan.xrp_ledger.tokens
17    WHERE (code LIKE '%USD%' OR code = 'RLUSD')
18        AND holders > 1000
19)
20SELECT 
21    supply_rank,
22    stablecoin_name,
23    token,
24    total_supply,
25    holders,
26    supply_rounded
27FROM ranked_stablecoins
28WHERE supply_rank BETWEEN 5 AND 10
29ORDER BY supply_rank;