title: SELECT COUNT() INSIDE A SELECT MAX() SQL
body: <p>I've got this table called <code>player_mast</code> in a db (data are just an example), and I want to find the club which supplied the most number of players to the 2016 EURO cup.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>player_id</th>
  <th>country_id</th>
  <th>jersey_no</th>
  <th>player_name</th>
  <th>posi_to_play</th>
  <th>dt_of_bir</th>
  <th>age</th>
  <th>playing_club</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1231</td>
  <td>1231</td>
  <td>10</td>
  <td>Hazard</td>
  <td>striker</td>
  <td>2/3/1991</td>
  <td>33</td>
  <td>Chelsea</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Why this query doesn't work? It seems right to me:</p>
  <pre><code>SELECT playing_club, MAX(NumberOfPlayerForTeam)
  FROM (
    SELECT playing_club, COUNT(player_id) AS NumberOfPlayerForTeam
    FROM player_mast
    GROUP BY(playing_club))
  GROUP BY(playing_club);
  </code></pre>