A SQL select statement with multiple joins

sql.sql

/*
Sample Data
-----------
                      movie
------------------------------------------------
id    title   yr    director    budget    gross

  actor
-----------
id    name

        casting
-----------------------
movieid   actorid   ord
*/

-- List the film title and the leading actor for all of the films 'John Travolta' played in.
SELECT movie.title, actor.name
FROM movie JOIN casting ON (movie.id = casting.movieid AND casting.ord = 1)
JOIN actor ON (actor.id = casting.actorid)
WHERE movie.id IN (SELECT casting.movieid FROM casting WHERE casting.actorid IN (SELECT actor.id FROM actor WHERE name = 'John Travolta'));