What are the top 10 oldest movies and what are the average rating score for each movie? Indicate the name of the director and when the movies were released.
the average rating score refers to AVG(T2.rating_score); oldest movies refers to MIN(rating_timestamp_utc)
SELECT T2.movie_id, AVG(T1.rating_score), T2.director_name, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_timestamp_utc ASC LIMIT 10