My Sql

The following is a correlated subquery, using the Sakila schema.

SELECT first_name, last_name FROM actor a

WHERE EXISTS

(SELECT * FROM film_actor WHERE actor_id = a.actor_id AND film_id = 10);

(a) [2 points] Write an equivalent noncorrelated subquery.

(b) [2 points] Write an equivalent query using JOIN and without subqueries.