CREATE TABLE reviewer (rid DECIMAL, name TEXT)
CREATE TABLE movie (mid DECIMAL, title TEXT, year DECIMAL, director TEXT)
CREATE TABLE rating (rid DECIMAL, mid DECIMAL, stars DECIMAL, 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