Using the knowledge of computational language in python it is possible to write a code that organizes film, actor and film and actor at the same time.
Writting the code:
SELECT a.last_name, a.first_name, ROUND(AVG(f.length)) AS 'average'
FROM film f
INNER JOIN film_actor fa ON f.film_id = fa.film_id
INNER JOIN actor a ON a.actor_id = fa.actor_id
GROUP BY a.last_name, a.first_name
ORDER BY average DESC, last_name ASC;
See more about python at brainly.com/question/18502436
#SPJ1
