I want to query the actor whos play both movie RANDOM GO and JASON TRAP

but it look like i can’t just use AND in my SQL Statement

Please Advise Me.

SELECT A.first_name, A.last_name, F.title FROM actor AS A
    JOIN film_actor AS Fa ON A.actor_id = Fa.actor_id
    JOIN film AS F ON F.film_id = Fa.film_id 
WHERE F.title = 'RANDOM GO' AND F.title ='JASON TRAP'
ORDER BY A.first_name;

SELECT A.first_name, A.last_name, F.title FROM actor AS A
    JOIN film_actor AS Fa ON A.actor_id = Fa.actor_id
    JOIN film AS F ON F.film_id = Fa.film_id 
WHERE F.title = 'RANDOM GO' 
ORDER BY A.first_name;

SELECT A.first_name, A.last_name, F.title FROM actor AS A
    JOIN film_actor AS Fa ON A.actor_id = Fa.actor_id
    JOIN film AS F ON F.film_id = Fa.film_id 
WHERE F.title = 'JASON TRAP' 
ORDER BY A.first_name;