title: "ORA-00933: SQL command not properly ended" error using Group By Clause
body: <p>I doing a few queries and I keep getting the same "ORA-00933: SQL command not properly ended" error. So here they are: </p>
  
  <p>--Artist of the song that has the most streams </p>
  
  <pre><code>SELECT ArtistID, NumberofStreams 
  FROM Songs 
  GROUP BY SongID 
  ORDER BY NumberOfStreams DESC 
  LIMIT 1;
  </code></pre>
  
  <p>--Returns oldest album and its Artist </p>
  
  <pre><code>SELECT ArtistName, AlbumName 
  FROM Album 
  ORDER BY ReleaseDate ASC 
  LIMIT 1;  
  </code></pre>
  
  <p>--Returns Artist with the most songs </p>
  
  <pre><code>SELECT ArtistID, COUNT(SongID) 
  FROM Songs 
  GROUP BY ArtistID 
  ORDER By COUNT(SongID) DESC 
  LIMIT 1; 
  </code></pre>
  
  <p>Tables are set up like this:</p>
  
  <p>Songs(SongID,ArtistID,SongName,SongName,SongLength)</p>
  
  <p>Album(AlbumID,AlbumName,ArtistID,ArtistName,NumberOfTracks,ReleaseDate)</p>
  
  <p>I think it has to do with my the ORDER BY or the LIMIT but I just cannot figure it out</p>