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

Group by not working

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 



FROM ratings

GROUP BY prod_id

Having count(ratings) >= 50 


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