title: Organizing teams by ability levels by using T-SQL but one team is of mixed ability level
body: <p>I have a table that displays teams by ability levels. One is all beginners, another is all advanced and a third is composed of beginners and advanced.</p>
  
  <pre><code>Team       Ability_Level  
  ------------------------
  Team 1     Beginners.  
  Team 2     Advanced.  
  Team 3     Beginners.  
  Team 3     Advanced.  
  Team 4     Beginners.  
  Team 4     Advanced.  
  Team 5     Advanced.  
  </code></pre>
  
  <p>The result should be:</p>
  
  <pre><code>Team 1  Beginners  
  ----------------------
  Team 2  Advanced  
  Team 3  Advanced  
  Team 4  Advanced  
  Team 5  Advanced  
  </code></pre>
  
  <p>Teams with all "advanced" or with "beginners and advanced" display as "advanced." The teams with only "beginners" will display as "beginners." </p>
  
  <p>I'd appreciate any help!       </p>