title: SQL Sum Multiple Rows Without Group By
body: <p>I have a query that correctly gets the sums and counts of the number of teams and number of people at an event. However, there can be multiple events at the same location on a single date, so I'm attempting to get a Sum of the total number of people at all events at a single location on a single day. 
  Here's the query I'm currently using:</p>
  
  <pre><code>SELECT 
  loc_name, 
  eventDate, 
  COUNT(t_ID) as Number_of_Teams, 
  SUM(NbrOfPeople) as Number_of_People
  FROM tblEventDate
  WHERE 
  eventID = 1 
  and eventDate &gt;='09/01/2013'
  GROUP BY loc_name, eventDate
  ORDER BY eventDate, loc_name
  </code></pre>
  
  <p>A sample dataset looks like this</p>
  
  <pre><code>loc_name |eventDate |Number_of_Teams |Number_of_people
  TCC      |2013-09-04|12              |38
  SMF      |2013-09-04|8               |12
  </code></pre>
  
  <p>This query, however, only gets me the Teams and People numbers where eventID = 1. I need to be able to get a sum where eventID IN (1,2,3,4,5) (maximum of 5 events per location per day) without having to include eventID in the GROUP BY clause. I'm a little bit stumped.</p>
  
  <p>I've tried CASE WHEN expressions, but that requires eventID in the GROUP BY which ultimately separates the value like this dataset.</p>
  
  <pre><code>loc_name |eventDate |eventID |Number_of_Teams |Number_of_people
  TCC      |2013-09-04|1       |12              |38
  TCC      |2013-09-04|2       |9               |22
  SMF      |2013-09-04|1       |8               |12
  SMF      |2013-09-04|2       |4               |9
  SMF      |2013-09-04|3       |13              |31
  </code></pre>
  
  <p>I've also tried nesting SELECT statements, but that was an abject failure. :-)</p>
  
  <p>Ultimately, I need a dataset that looks like:</p>
  
  <pre><code>loc_name |eventDate |Number_of_Teams |Number_of_people
  TCC      |2013-09-04|21              |60
  SMF      |2013-09-04|25              |52
  </code></pre>
  
  <p>Notice that the Number_of_Teams is the full count of all teams across all events at the location on that day, and the Number_of_People is the full sum of all the members of each team across all events at that location on that day.</p>
  
  <p>Any thoughts would be appreciated.</p>