DROP TABLE if exists rss_desc;

CREATE TABLE rss_desc (
        id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
        details XML
);

insert into rss_desc (details) values (XMLPARSE(DOCUMENT '<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" version="2.0">
   <channel>
      <title>CoinGape</title>
      <link>https://coingape.com/</link>
      <description>CoinGape - 24*7 Crypto Updates</description>
      <item>
         <title>Arthur Hayes Predicts Bitcoin Rally To $500K By Next Year Over Fed Easing</title>
         <description><![CDATA[<p>BitMEX co-founder Arthur Hayes has predicted that Bitcoin&#8217;s price could rally to $500,000 by the end of next year. Hayes indicated that this price surge would happen on the back of quantitative easing (QE) from the Fed, with rate-cut advocate Kevin Hassett the frontrunner to become the next chair. Bitcoin Could Reach $500k By Year-End</p><p>The post <a href="https://coingape.com/arthur-hayes-predicts-bitcoin-rally-to-500k-by-next-year-over-fed-easing/">Arthur Hayes Predicts Bitcoin Rally To $500K By Next Year Over Fed Easing</a> appeared first on <a href="https://coingape.com">CoinGape</a>.</p>]]></description>
         <media:content xmlns:media="http://search.yahoo.com/mrss/" medium="image" url="https://coingape.com/wp-content/uploads/2025/11/Arthur-Hayes-Predicts-Bitcoin-Rally.webp" width="460" height="230" />
      </item>
      <item>
         <title>Solana Price Outlook as CoinShares Withdraws SEC Filing for Staked Solana ETF</title>
         <description><![CDATA[<p>Solana price remains steady above the $130 level, despite a slight 2% decrease in the last 24 hours. Over the past week, the cryptocurrency has gained 8%, signaling a potential recovery.   CoinShares has dropped its applications to trade spot ETFs that concentrate on Solana, XRP, and Litecoin, which has cast an envelop of uncertainty on</p><p>The post <a href="https://coingape.com/markets/solana-price-outlook-as-coinshares-withdraws-sec-filing-for-staked-solana-etf/">Solana Price Outlook as CoinShares Withdraws SEC Filing for Staked Solana ETF</a> appeared first on <a href="https://coingape.com">CoinGape</a>.</p>]]></description>
         <media:content xmlns:media="http://search.yahoo.com/mrss/" medium="image" url="https://coingape.com/wp-content/uploads/2025/11/analyst_who_accurately_predicted_solana_price_correction_shares_ath_target.webp" width="460" height="230" />
      </item>
   </channel>
</rss>'));

SELECT
    rss.description
FROM
    rss_desc d,
    XMLTABLE('/rss/channel/item' PASSING d.details
        COLUMNS
            description text PATH 'description/text()'
    ) AS rss;