create a  query to write list of all actors who played in a movie called "AMADEUS HOLY".  

SELECT f.title AS FilmTitle, CONCAT(last_name, ', ', first_name) AS ActorName FROM film f JOIN film_actor fa ON f.film_id = fa.film_id JOIN actor a ON fa.actor_id = a.actor_id WHERE title = 'AMADEUS HOLY';

Answer rating: 100% (QA)

SELECT ActorsActorName FROM Actors INNER ... View the full answer