SELECT mID ,  avg(stars) FROM Rating GROUP BY mID HAVING count(*)  >=  2
For each movie that received more than 3 reviews, what is the average rating?
SELECT mID , avg ( stars ) FROM Rating GROUP BY mID HAVING count ( * ) > = 2
select mid , avg ( stars ) from rating group by mid having count ( * ) > = value
For each movie that received more than 3 reviews , what is the average rating ?