title: Using Count in SQL Server
body: <p>I am trying to run a query in SQL Server to loop through the associates and count how many transactions they processed.</p>
  
  <pre><code>select 
      Id, submitter_name, submitter_id,
      count(*) as numberOfTickets
  from
      Tickets 
  where 
      created_at between '2018-11-13' and '2018-11-14' 
      and ',' + tags + ',' like '%,' + 'tickets' + ',%'
  group by 
      Id, submitter_name, submitter_id;
  </code></pre>
  
  <p>This results shows the associates name over and over with one transaction. I am trying to count and show there name once with the total count for <code>numberOfTickets</code>.</p>
  
  <p>I am not sure where I am going wrong here. Any help would be greatly appreciated!</p>