Write a query for an SQL database.
Input: A movie database which has a table of 'movies' and a table of 'actors'.
SELECT * FROM movies
WHERE actor_id IN (SELECT actor_id FROM actors);
SELECT * FROM movies;
SELECT * FROM actors;