title: Having Top team of every season (only one)
body: <p>I want only top teams whose wins are most in each season.</p>
  <p><a href="https://i.stack.imgur.com/ysHzV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ysHzV.png" alt="enter image description here" /></a></p>
  <p><strong>I want my Result set as Season: 1900 team_name: 'a' wins:4 and like this for 1901 it will be Team: 'b' wins:5</strong></p>
  <p>If there are two teams wins same then my query should pick the first one alphabetically like in my case it will pick Team: 'a' for season 1900</p>
  <p>Source Query</p>
  <pre><code>create table #teams( season varchar(100), team_name varchar(100),win int);
  
  insert #teams (season , team_name ,win)
  select '1900','a' , 4;
  
  insert #teams (season , team_name ,win)
  select '1900','b' , 4;
  
  insert #teams (season , team_name ,win)
  select '1900','c' , 2;
  
  insert #teams (season , team_name ,win)
  select '1901','a' , 3;
  
  insert #teams (season , team_name ,win)
  select '1901','b' , 5;
  
  insert #teams (season , team_name ,win)
  select '1901','c' , 5;
  
  select * from #teams;
  
  select season ,team_name , max(win) as wins
  from #teams
  group by season, team_name
  order by season
  
  </code></pre>