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"