# a) List the actors (firstName, lastName) who acted in more then 25 movies. # Note: Also show the count of movies against each actor # b) List the actors who have worked in the German language movies. # Note: Please execute the below SQL before answering this question. SET SQL_SAFE_UPDATES=O; UPDATE film SET language_id=6 WHERE title LIKE "%ACADEMY%"; # c) List the actors who acted in horror movies. # Note: Show the count of movies against each actor in the result set. # d) List all customers who rented more than 3 horror movies