title: How to return the SUM of a COUNT in PL/SQL
body: <p><strong>Scenario:</strong> I am trying to build a query that will return the SUM of a COUNT.<br>
  <strong>Purpose of the Query:</strong> I need to identify all of our Participants that are currently listed on 2 or more Positions.</p>
  
  <p><strong>Current Query:</strong></p>
  
  <pre><code>select pa.firstname, pa.lastname, pos.name as "POSITION", count(pos.name) as "POSITION COUNT"
  
  from cs_participant pa, cs_position pos
  
  where pa.payeeseq = pos.payeeseq
  and pa.firstname like '%DEV%'
  and pa.lastname like '%TEST%'
  
  group by pa.firstname, pa.lastname, pos.name
  </code></pre>
  
  <p><strong>Results:</strong><br>
  <img src="https://i.stack.imgur.com/SrpKX.png" alt="enter image description here"></p>
  
  <p>I need to SUM the POSITION COUNT and somehow return only FIRSTNAME, LASTNAME, and SUM. So, if a Participant is currently on 2 or more Positions, the query would return the Participant's FIRSTNAME, LASTNAME, and SUM of POSITIONS.<br><br>
  If I could also return the POSITION in the far column without creating duplicate rows for each unique POSITION, that would be a huge help!<br><br>
  For example, a Participant with 2 POSITIONS would return the Participant's FIRSTNAME, LASTNAME, SUM OF POSITIONS, and POSITION_1 on the first row, while the second row would have blank values for the Participant's FIRSTNAME, LASTNAME, and SUM of POSITIONS, but return POSITION_2 in the 4th column (Similar to a "break" function in Web Intelligence).<br><br></p>
  
  <p>Thanks!</p>