title: Can I select the count of rows in another table that have the same value as the FK in that table?
body: <p>Sorry If that's terrible phrasing. Basically I need to make a query that tells me the club name and description from 'clubs', with the total number of students in that club. Students can only be in 1 club so clubID is a Foreign key in 'students'.</p>
  <p>I tried to use the below, but quickly learned I'm nowhere near the answer. Is this possible?</p>
  <pre><code>SELECT clubs.clubName, clubs.clubDescription, COUNT(students.studentID) 
  FROM club JOIN students ON students.clubID = clubs.clubID
  </code></pre>