title: Sum() function with over not work in Room database android
body: <p>Can anyone help me the below query is working fine in DB Browser but not work with the <code>Room</code> database. Here are the table and query:</p>
  <p>Table <code>Transaction</code>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>amount</th>
  <th>is_credit</th>
  </tr>
  </thead>
  </table>
  </div>
  <p>Query:</p>
  <pre><code>SELECT * 
  FROM 
      (SELECT 
           id, amount, 
           SUM(CASE WHEN is_credit = 1 THEN amount ELSE -amount END) OVER (ORDER BY id) AS balance 
       FROM `Transaction`) 
  ORDER BY 
      id DESC;
  </code></pre>
  <p>I have tried this query with <code>SimpleSQLiteQuery</code> but I'm getting error :</p>
  <blockquote>
  <p>E/SQLiteLog: (1) near &quot;(&quot;: syntax error</p>
  </blockquote>