movie:
    id       integer
    name     varchar
    director integer foreign key director.id

director:
    id     integer
    person integer foreign key person.id
    salary float

roles:
    movie  integer foreign key movie.id
    person integer foreign key person.id
    type   enum ('lead', 'supporting', 'bit')

person:
    id   integer
    name varchar

##</code><code>##

SELECT d_p.name AS director_name
      ,l_p.name AS lead_name
  FROM movie m
  JOIN director d ON (d.id = m.director)
  JOIN person d_p ON (d.person = person.id)
  JOIN roles r ON (r.movie = movie.id)
  JOIN person l_p ON (r.person = person.id)
 WHERE movie.name = ?
   AND r.type = 'lead'