Which film actors and actresses played a role in more than 30 films? List their first and last names.
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
How many films was actor id 9 in?
select count ( * ) from film_actor where actor_id = '9'
What's that person's name?
select first_name,last_name from actor where actor_id = '9'
Is there anyone else with the first name Joe?
select first_name, last_name from actor where first_name = 'JOE' and last_name ! = 'SWANK'