SELECT T2.first_name ,  T2.last_name FROM film_actor AS T1 JOIN actor AS T2 ON T1.actor_id  =  T2.actor_id GROUP BY T2.actor_id HAVING count(*)  >  30
What are the full names of actors who had roles in more than 30 films?
SELECT T2.first_name , T2.last_name FROM film_actor AS T1 JOIN actor AS T2 ON T1.actor_id = T2.actor_id GROUP BY T2.actor_id HAVING count ( * ) > 30
select t2 . first_name , t2 . last_name from film_actor as t1 join actor as t2 on t1 . actor_id = t2 . actor_id group by t2 . actor_id having count ( * ) > value
What are the full names of actors who had roles in more than 30 films ?