WITH meme_coins AS (
SELECT * FROM (VALUES
('Dogecoin', 9500000000, 1200000000, 5.6),
('Shiba Inu', 7300000000, 800000000, -2.3),
('Floki Inu', 500000000, 50000000, 12.1),
('SafeMoon', 450000000, 30000000, -8.4),
('Kishu Inu', 200000000, 10000000, 3.3),
('Dogelon Mars', 150000000, 20000000, 0.9)
) AS t(coin_name, market_cap, trading_volume, price_change_7d)
)
SELECT
coin_name AS "Meme Coin",
market_cap AS "Market Cap ($)",
trading_volume AS "24-Hour Trading Volume ($)",
price_change_7d AS "7-Day Price Change (%)"
FROM meme_coins
ORDER BY market_cap DESC;