title: How to run an aggregate function like SUM on two columns in JPA and display their results?
body: <p>I am new to JPA. So my question should be so simple to some.</p>
  
  <p>Below is the Simple Query in SQL which i would like to convert to JPA. I already have an entity class called <code>TimeEnt</code>.</p>
  
  <pre><code>SELECT 
       SUM(TimeEntryActualHours) as UnBilledHrs,
       SUM (TimeEntryAmount) as UnbilledAmount
  FROM TimeEnt WHERE MatterID = 200
  </code></pre>