CREATE TABLE reviewer (rid NUMBER, name CLOB)
CREATE TABLE movie (mid NUMBER, title CLOB, year NUMBER, director CLOB)
CREATE TABLE rating (rid NUMBER, mid NUMBER, stars NUMBER, ratingdate TIME)

Find the average rating star for each movie that received at least 2 ratings.
SELECT mid, AVG(stars) FROM rating GROUP BY mid HAVING COUNT(*) >= 2
SELECT "mid", AVG("stars") FROM "rating" GROUP BY "mid" HAVING COUNT(*) >= 2