title: Trying to figure out how to find the max count
body: <blockquote>
    <p>Which team has the most number of members on their roster?</p>
  </blockquote>
  
  <p>Okay so below is the code that I have input currently. It returns all the teams as well as how many people are on each team. I am not sure how to code it to only display the team with the most members as when I try to use a max function and a count function I get an error.</p>
  
  <pre><code>SELECT Team_Name, COUNT(Member.Student_ID_Num) 
  FROM Teams 
  JOIN Member ON Teams.Team_Number = Member.Team_Number 
  GROUP BY Team_Name
  </code></pre>