Support Questions
Find answers, ask questions, and share your expertise

Group by not working

Highlighted

Group by not working

New Contributor

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"