null00

Hi, so I have been trying to get this to work but I haven't been able to. I am supposed to do this: "Using the Sakila database, give me a combined list of films that have an actor with the last name Depp and the actors in the film Ace Goldfinger. Order the output by type ascending." I have this coded and yet it will not return what I need it to. SELECT NOW() firstlastname, CONCAT(actor.first_name,' ', actor.last_name) AS film_or_actor , 'Actor' AS type FROM actor INNER JOIN film_actor ON actor.actor_id = film_actor.actor_id INNER JOIN film ON film_actor.film_id = film.film_id INNER JOIN film_text ON film_text.title = film.title INNER JOIN film_list ON film.film_id = film_list.FID WHERE actor.last_name LIKE '%depp%' UNION SELECT NOW() firstlastname, film.title AS film_or_actor, 'Film' AS type FROM actor INNER JOIN film_actor ON actor.actor_id = film_actor.actor_id INNER JOIN film ON film_actor.film_id = film.film_id INNER JOIN film_text ON film_text.title = film.title INNER JOIN film_list ON film.film_id = film_list.FID WHERE film_list.actors IN film.film_id = 2 ORDER BY type ASC; any help would be appreciated.