-- Database schema
| actor : actor_id [ INT ] primary_key , first_name [ TEXT ] , last_name [ TEXT ] , last_update [ TEXT ] | address : address_id [ INT ] primary_key , address [ TEXT ] , address2 [ TEXT ] , district [ TEXT ] , city_id [ INT ] address.city_id = city.city_id , postal_code [ TEXT ] , phone [ TEXT ] , last_update [ TEXT ] | category : category_id [ INT ] primary_key , name [ TEXT ] , last_update [ TEXT ] | city : city_id [ INT ] primary_key , city [ TEXT ] , country_id [ INT ] city.country_id = country.country_id , last_update [ TEXT ] | country : country_id [ INT ] primary_key , country [ TEXT ] , last_update [ TEXT ] | customer : customer_id [ INT ] primary_key , store_id [ INT ] customer.store_id = store.store_id , first_name [ TEXT ] , last_name [ TEXT ] , email [ TEXT ] , address_id [ INT ] customer.address_id = address.address_id , active [ TEXT ] , create_date [ TEXT ] , last_update [ TEXT ] | film : film_id [ INT ] primary_key , title [ TEXT ] , description [ TEXT ] , release_year [ TEXT ] , language_id [ INT ] film.language_id = language.language_id , original_language_id [ INT ] film.original_language_id = language.language_id , rental_duration [ INT ] , rental_rate [ INT ] , length [ INT ] , replacement_cost [ INT ] , rating [ TEXT ] , special_features [ TEXT ] , last_update [ TEXT ] | film_actor : actor_id [ INT ] primary_key film_actor.actor_id = actor.actor_id , film_id [ INT ] film_actor.film_id = film.film_id , last_update [ TEXT ] | film_category : film_id [ INT ] primary_key film_category.film_id = film.film_id , category_id [ INT ] film_category.category_id = category.category_id , last_update [ TEXT ] | film_text : film_id [ INT ] primary_key , title [ TEXT ] , description [ TEXT ] | inventory : inventory_id [ INT ] primary_key , film_id [ INT ] inventory.film_id = film.film_id , store_id [ INT ] inventory.store_id = store.store_id , last_update [ TEXT ] | language : language_id [ INT ] primary_key , name [ TEXT ] , last_update [ TEXT ] | payment : payment_id [ INT ] primary_key , customer_id [ INT ] payment.customer_id = customer.customer_id , staff_id [ INT ] payment.staff_id = staff.staff_id , rental_id [ INT ] payment.rental_id = rental.rental_id , amount [ INT ] , payment_date [ TEXT ] , last_update [ TEXT ] | rental : rental_id [ INT ] primary_key , rental_date [ TEXT ] , inventory_id [ INT ] rental.inventory_id = inventory.inventory_id , customer_id [ INT ] rental.customer_id = customer.customer_id , return_date [ TEXT ] , staff_id [ INT ] rental.staff_id = staff.staff_id , last_update [ TEXT ] | staff : staff_id [ INT ] primary_key , first_name [ TEXT ] , last_name [ TEXT ] , address_id [ INT ] staff.address_id = address.address_id , picture [ TEXT ] , email [ TEXT ] , store_id [ INT ] , active [ TEXT ] , username [ TEXT ] , password [ TEXT ] , last_update [ TEXT ] | store : store_id [ INT ] primary_key , manager_staff_id [ INT ] store.manager_staff_id = staff.staff_id , address_id [ INT ] store.address_id = address.address_id , last_update [ TEXT ] |
-- -- 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;