I'm having a ton of trouble thinking in terms of SQL on problems like this. I don't know how I should be structuring my queries. Should I be joining
SELECT * FROM (actor JOIN film_actor ON actor.actor_id=film_actor.actor_id) WHERE first_name = 'ADAM' AND last_name = 'GRANT'
SELECT title FROM (actor JOIN film_actor ON actor.actor_id=film_actor.actor_id) WHERE first_name = 'ADAM' AND last_name = 'GRANT' JOIN film ON film.actor_id = actor_id
You should use inner join
SELECT film.title , language.name FROM film INNER JOIN language on film.language_id = language.language_id INNER JOIN film_actor on film.film_id = film_actor.film_id INNER JOIN actor on actor.actor_id = film_actor.actor_id WHERE actor.first_name = 'ADAM' AND actor.last_name ='GRANT'