Group by not working

[#1]

I have a table ratings with columns posted(timestamp), cust_id (int), prod_id(int), rating(tinyint), message(string). 

I want to have the following query 

SELECT *

FROM ratings

GROUP BY prod_id

Having count(ratings) >= 50 

But I continuously get the error, "Expression not in group by key"