---

SELECT p.name
FROM Roles r
JOIN Performances p ON r.performance_id = p.id
WHERE r.role_type = 'главная'
GROUP BY p.name
HAVING COUNT(*) > 3;