10) Show the names of actors who have worked in movies with a rank in the top 10 inclusive.
Show the movie titles worked in and rank. Sort in descending order of rank.
SELECT TOP 10 actors.*, movies.title
FROM actors
INNER JOIN movies on movies.movieid=actors.movieid
INNER JOIN ratings on movies.movieid=ratings.movieid
ORDER BY ratings.rank DESC