title: How to group two categories as a one group in SQL
body: <p>I want to group <code>C,C++,C# and VB,VB.NET</code> as a different single category with summarized result. Do I need to substitute the team name into a unified value <code>(e.g. replace C,C++,C# into "C related")</code> and then do the grouping?</p>
  
  <p>Which one is better in terms of performance? do i need to use Store procedures?
  Can someone please advise me how to do it? Thanks!</p>
  
  <p>PS: I am using SQL server</p>
  
  <p><strong>Original table</strong></p>
  
  <pre><code>INSERT INTO Table1
      ([Team], [Room])
  VALUES
      ('Java', 'Room A'),
      ('Java', 'Room B'),
      ('Java', 'Room C'),
      ('Java', 'Room A'),
      ('Java', 'Room C'),
      ('C++', 'Room A'),
      ('C++', 'Room B'),
      ('C++', 'Room C'),
      ('C', 'Room A'),
      ('C', 'Room B'),
      ('C', 'Room C'),
      ('VB', 'Room B'),
      ('VB', 'Room C'),
      ('C#', 'Room A'),
      ('C#', 'Room B'),
      ('C#', 'Room C'),
      ('VB.Net', 'Room A'),
      ('VB.Net', 'Room B'),
      ('VB.Net', 'Room C')
  </code></pre>
  
  <p><strong>Expected output</strong></p>
  
  <pre><code>('Team', 'Room', 'Count'),
  ('Java', 'Room A', 2),
  ('Java', 'Room B', 1),
  ('Java', 'Room C', 2),
  ('C related', 'Room A', 3),
  ('C related', 'Room B', 3),
  ('C related', 'Room C', 3),
  ('VB related', 'Room A', 1),
  ('VB related', 'Room B', 2),
  ('VB related', 'Room C', 2)
  </code></pre>