1WITH meme_coins AS (
2  SELECT * FROM (VALUES
3    ('Dogecoin', 9500000000, 1200000000, 5.6),
4    ('Shiba Inu', 7300000000, 800000000, -2.3),
5    ('Floki Inu', 500000000, 50000000, 12.1),
6    ('SafeMoon', 450000000, 30000000, -8.4),
7    ('Kishu Inu', 200000000, 10000000, 3.3),
8    ('Dogelon Mars', 150000000, 20000000, 0.9)
9  ) AS t(coin_name, market_cap, trading_volume, price_change_7d)
10)
11
12SELECT 
13  coin_name AS "Meme Coin",
14  market_cap AS "Market Cap ($)",
15  trading_volume AS "24-Hour Trading Volume ($)",
16  price_change_7d AS "7-Day Price Change (%)"
17FROM meme_coins
18ORDER BY market_cap DESC;
19