CREATE TABLE Reviewer (rID NUMBER, name CLOB)
CREATE TABLE Rating (rID NUMBER, mID NUMBER, stars NUMBER, ratingDate DATE)
CREATE TABLE Movie (mID NUMBER, title CLOB, year NUMBER, director CLOB)

Find the average rating star for each movie that received at least 2 ratings.
SELECT mID, AVG(stars) FROM Rating GROUP BY mID
SELECT "mID", AVG("stars") FROM "Rating" GROUP BY "mID"