SELECT first_name, last_name,
COUNT(*) as film_count
FROM	actor
JOIN film_actor on
film_actor.actor_id = actor.actor_id
JOIN film on film_actor.film_id = film.film_id
WHERE length > 90
GROUP BY first_name, last_name


SELECT 
CONCAT(first_name, '' , last_name) as actor
, COUNT(f.title) as number_of_Films
FROM actor
join film_actor AS fa on actor.actor_id = fa.actor_id
join film AS f on f.film_id = fa.film_id
GROUP BY 
actor
ORDER BY Number_of_films DESC

SELECT selected_actors.first_name, selected_actors.last_name, SUM (payment,amount) as Zarobki
FROM(
SELECT first_name,last_name, actor.actor_id, COUNT (8) as film_count
FROM actor
JOIN film_actor on film_actor.actor_id = actor.actor_id
JOIN film on film_actor.film_id =film.film_id
WHERE length >90
GROUP BY first_name.last_name