MYSQL

Find the first_name, last_name and total_combined_film_length of Sci-Fi films for every actor.

That is the result should list the names of all of the actors(even if an actor has not been in any Sci-Fi films) and the total length of Sci-Fi films they have been in.

Look at the category table to figure out how to filter data for Sci-Fi films.

Order your results by the actor_id in descending order.

film film_id title description release year language_id original_language_i rental_duration rental_rate length replacement_cost category category_id name last_update language language_id name last_update film_category filmid category_id last_update actor actor_id first_name last_name last_update actor_id last_update film_id film_actor