SELECT
       s.name,
       COUNT(p.film_id) `films count`,
       COUNT(p.id) `amount count`,
       SUM(p.amount) `sum amount`,
       AVG(p.amount) `avg amount`
FROM films
JOIN studios s ON films.studio_id = s.id
JOIN payments p ON films.studio_id = s.id
WHERE p.actor_id = 1
GROUP BY p.actor_id;