What is the average rating for all movies?
SELECT T2.title ,avg ( T1.stars )  FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID   =   T2.mID GROUP BY T1.mID
average rating for all movies refers to AVG(stars);