Write a sql query that will produce a result set containing a list of films and the actors that played in them. The table should have the film name, and the first and last names of the actors. You will see the film name repeated for every actor that is in the film.

film film_id title description release-year language-id original-language-id rental, duration film actor t actor_id film_id last_update Indexes actor actor id first_name last_name last-update Indexes rental-rate length replacement-cost rating special-features last_update Indexes Triggers