Actors and Their Primary Movie

Problem

Write a query that returns each actor's name (aliased as actor_name) alongside the title of their primary movie (aliased as movie_title), by joining actors to movies. Order the results by movie_title.

Try It

Hint

Solution