human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the rating star for all the movies?
assistant
SELECT mID , stars FROM Rating;
human
Give me the average rating star for each movie.
assistant
SELECT mID , AVG ( stars ) FROM Rating GROUP BY mID ;