SELECT mID ,  avg(stars) FROM Rating GROUP BY mID HAVING count(*)  >=  2
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 ( * ) > = value
Find the average rating star for each movie that received at least 2 ratings .