SELECT id_film, titre, nom AS "nom distrib"
FROM film
NATURAL JOIN distrib AS a
WHERE a.id_distrib IN (
      SELECT id_distrib
      FROM distrib AS b
      NATURAL JOIN film
      GROUP BY b.id_distrib
      HAVING COUNT(*) > 10
      )
ORDER BY nom ASC;