list out the movies on the table
select * from movie
what is the director name of Star Wars
select director from movie where title = 'Star Wars'
exactly
select * from rating as t1 join movie as t2 on t1.mid = t2.mid order by t1.stars desc limit 1
what is the year of Gone with the Wind
select year from movie where title = 'Gone with the Wind'