Incorrect syntax near COUNT(*) : <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>
