How many films are there?
select count ( * ) from film
What is the range of dates they were made?
select min ( release_year ), max ( release_year ) from film
What is the range of rental cost for the films?
select min ( rental_rate ), max ( rental_rate ) from film
film name?
select t2.title 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
film id?
select t2.film_id 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
film description?
select 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