title: SQL - How to display the students with the same age?
body: <p>the code I wrote only tells me how many students have the same age. I want their names too...</p>
  
  <pre><code>SELECT YEAR(CURRENT DATE-DATEOFBIRTH) AS AGE, COUNT(*) AS HOWMANY
  FROM STUDENTS
  GROUP BY YEAR(CURRENT DATE-DATEOFBIRTH);
  </code></pre>
  
  <p>this returns something like this:</p>
  
  <pre><code>AGE      HOWMANY
  ---      -------
  21       3
  30       5
  </code></pre>
  
  <p>Thank you.</p>
  
  <pre><code>TABLE STUDENTS COLUMNS:
  StudentID (primary key), Name(varchar), Firstname(varchar), Dateofbirth(varchar)
  </code></pre>
  
  <p>I was thinking of maybe using the code above and somewhere add the function concat that will put the stundents' names on the same row as in </p>