Table Movies: [ MovieID / MovieName / MovieYear]

Table Reviews: [ReviewID / MovieID / userID / Rating / ReviewDate]

SELECT
  Movies.MovieID,
  Movies.MovieName,
  COUNT(Reviews.MovieID) AS NumReviews,
  AVG(CONVERT(float, COUNT(Rating) )) AS  AvgRating
FROM
  Movies
  JOIN Reviews ON(Reviews.MovieID = Movies.MovieID)
GROUP BY
  Movies.MovieID,
  Movies.MovieName