Tell me the films which BETTE participated in.
select t2.title from film_actor as t1 join film as t2 on t1.film_id = t2.film_id join actor as t3 on t1.actor_id = t3.actor_id where t3.first_name = "BETTE"
How about the films which JOE starred in?
select t2.title from film_actor as t1 join film as t2 on t1.film_id = t2.film_id join actor as t3 on t1.actor_id = t3.actor_id where t3.first_name = "JOE"
Which film has the most number of actors or actresses? List the film name, film id and description.
select t2.title, t2.film_id, t2.description from film_actor as t1 join film as t2 on t1.film_id = t2.film_id group by t2.film_id order by count(*) desc limit 1