title: converting mysql query to redbean query
body: <p>Can anyone help me convert this mysql query to redbean query please?</p>
  
  <pre><code>SELECT category,sum(price) from transaction GROUP BY category.
  </code></pre>