title: Incorrect syntax near COUNT(*)
body: <pre><code>SELECT D.Drank_Naam , D.Drank_Prijs, SUM(K.Aantal) AS Aantal COUNT(*) AS StudentDeelnemer,
              + FROM Kassa K,
              + JOIN DrankVoorraad AS D ON K.Drink_ID = D.ID,
              + JOIN StudentDeelnemer AS S on K.Student_Id = S.StudentNummer, 
              + group by D.Drank_Naam, D.Drank_Prijs;
  </code></pre>
  
  <p>I want to calculate the sum of drinks sold and the price, but i get an incorrect syntax near COUNT(*)</p>