What are the ratingDate of mID 101?
select ratingdate from rating where mid = 101
Find The releasing year of The Sound of Music.
select year from movie where title = "The sound of Music"
Yes
select director from movie where title = "Star Wars"
What is the average rating stars and title for the oldest movie?
select avg ( t1.stars ), t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid where t2.year = ( select min ( year ) from movie )