Question: 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, ', ',

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';

Step by Step Solution

3.42 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SELECT ActorsActorName FROM Actors INNER ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!