title: Add and filter by lower values ​(MYSQL)
body: <p>I have to do that: Get the name of the singer who recorded with the most different record labels.</p>
  <p>So, I have three tables, they are:</p>
  <p>singer:
  <code>cod_singer</code>
  <code>name_singer</code></p>
  <p>recording:
  <code>cod_recording</code>
  <code>cod_singer</code>
  <code>record_company</code>
  <code>cod_song</code></p>
  <p>record_company:
  <code>record_company</code>
  <code>country</code>
  <code>cod_song</code></p>
  <p>Currently, I can get the singers and the different recordings of each singer with the code below:</p>
  <pre><code>SELECT DISTINCT s.nome_singer
                , r.cod_reccord  
             FROM singer s
             JOIN reccord r
               ON s.cod_singer = r.cod_singer;
  </code></pre>
  <p>But I don't know can I get how many record labels each singer recorded, I know that I have to use a <code>count</code> and maybe <code>having</code>.</p>