Baselight
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;
Meme CoinMarket Cap ($)24-Hour Trading Volume ($)7-Day Price Change (%)
Dogecoin950000000012000000005.6
Shiba Inu7300000000800000000-2.3
Floki Inu5000000005000000012.1
SafeMoon45000000030000000-8.4
Kishu Inu200000000100000003.3
Dogelon Mars150000000200000000.9

Share link

Anyone who has the link will be able to view this.