Find the average rating star for each movie that received at least 2 ratings.
CREATE TABLE Rating (mID VARCHAR, stars INTEGER)
SELECT mID, AVG(stars) FROM Rating GROUP BY mID HAVING COUNT(*) >= 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Rating (mID VARCHAR, stars INTEGER) Question: Find the average rating star for each movie that received at least 2 ratings. [/INST] SELECT mID, AVG(stars) FROM Rating GROUP BY mID HAVING COUNT(*) >= 2 </s>