title: SQL - Selecting the most occurring value
body: <p>I have a very simple database consisting of these tables. Here I am trying to write a query to select the player who played in the most games from the Games table. </p>
  
  <p>Just by looking at the below example you can tell that the answer is Ben of course, because PID 2 (which is Ben from the Players table) appears the most times in the Games table, meaning Ben won the most games.</p>
  
  <p>But I am not sure how to write the query for selecting the most recurring value in the Games table.</p>
  
  <pre><code>Players         Games          
  
  PID | name      GID | PID
  ----|-----      ----|------
  1   |  Al       A   |  3
  2   |  Ben      A   |  2
  3   |  Carl     A   |  2
  4   |  Jack     A   |  1
  5   |  Ron      A   |  4
  </code></pre>
  
  <p>Does anyone have any suggestions? Thanks!</p>