title: How can I take the sum of column and display it in ListView?
body: <p>I want to take sum of a specific database column (the <code>amount</code> column) where the area equals a user defined area. How could I get this?</p>
  
  <p>I have tried:</p>
  
  <pre><code> cursor=db.rawquery("SELECT sum(amt) as Sum FROM mytable WHERE area LIKE ?", null);
  </code></pre>
  
  <p>Now I want to show this result in <code>ListView</code>. How do I display it and is the above syntax correct?</p>