title: Selecting the name and the number of albums from a database
body: <p>I have the following database (<a href="http://blog.xojo.com/wp-content/uploads/2016/04/ChinookDatabaseSchema1.1.png" rel="nofollow noreferrer">http://blog.xojo.com/wp-content/uploads/2016/04/ChinookDatabaseSchema1.1.png</a>) and I would like to select the name of the artist and the number of albums the artist has recorded, but every time i run the code, it displays the 1st name and the total number of albums. </p>
  
  <p>This is my code:</p>
  
  <pre><code>SELECT Name, count(*)
  FROM album
  INNER JOIN artist
  ON album.ArtistId = artist.ArtistId;
  </code></pre>